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=#
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 |