The following bug has been logged online:
Bug reference: 5484
Logged by: Sergey
Email address: viras@yandex.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@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=#