The following bug has been logged online:
Bug reference: 3467
Logged by: Alex
Email address: AVShutko(at)mail(dot)khstu(dot)ru
PostgreSQL version: 8.2.4
Operating system: FreeBSD 6.2-RELEASE-p4
Description: Sum strange behaviour
Details:
I have a database with some float numbers (all of them are 2 digits
presision). When I do select sum() I get this: 96.3100000000001
Here are the numbers:
4.29
4.29
0.29
14.3
1.43
14.3
1.43
1.43
7.15
2.94
0.14
5.56
1.43
0.29
0.59
1.43
1.43
1.43
1.43
21.45
1.43
0.14
2.15
1.43
1.43
1.43
1.43
0.59
0.22
1.43
1.18
Is this bug or future ?