BUG #5484: sum() bug - Mailing list pgsql-bugs

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