Skip site navigation (1) Skip section navigation (2)

BUG #5484: sum() bug

From: "Sergey" <viras(at)yandex(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5484: sum() bug
Date: 2010-05-30 14:48:53
Message-ID: 201005301448.o4UEmrGw071482@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5484
Logged by:          Sergey
Email address:      viras(at)yandex(dot)ru
PostgreSQL version: 8.4.4
Operating system:   FreeBSD 7.3
Description:        sum() bug
Details: 

Function sum() bug.
8849.15+6464.57=15313.72
But sum()=15313.7

[root(at)proxy ~]# psql -U pgsql megafon
psql (8.4.4)
Type "help" for help.

megafon=# SELECT version();
                                                 version                    
                       
----------------------------------------------------------------------------
-----------------------------
 PostgreSQL 8.4.4 on i386-portbld-freebsd7.3, compiled by GCC cc (GCC) 4.2.1
20070719  [FreeBSD], 32-bit
(1 row)

megafon=#
megafon=# SELECT * from aaa;
   num
---------
 8849.15
 6464.57
(2 rows)

megafon=# SELECT sum(num) from aaa;
   sum
---------
 15313.7
(1 row)

megafon=#

Responses

pgsql-bugs by date

Next:From: Daniele VarrazzoDate: 2010-05-30 16:59:36
Subject: Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation
Previous:From: Matthew NourseDate: 2010-05-30 09:53:52
Subject: Re: BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group