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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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