The following bug has been logged online:

Bug reference:      3467
Logged by:          Alex
Email address:      [EMAIL PROTECTED]
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 ?

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to