> 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
> Is this bug or future ?
A feature. Floating point numbers can't generally represent a decimal
number exactly, so you get some rounding errors. Usually the errors are
small enough that they don't show up, but sometimes they do, like in
this example. I would recommend using NUMERIC instead of floats for
anything where the input data is in decimal format.
In response to
pgsql-bugs by date
|Next:||From: SRIDHARAN||Date: 2007-07-18 11:34:51|
|Subject: BUG #3469: SELECT QRY|
|Previous:||From: Alex||Date: 2007-07-18 09:26:46|
|Subject: BUG #3467: Sum strange behaviour|