Re: [BUGS] BUG #3467: Sum strange behaviour

2007-07-18 Thread Heikki Linnakangas
Alex wrote: > I have a database with some float numbers (all of them are 2 digits > presision). When I do select sum() I get this: 96.31001 > ... > Is this bug or future ? A feature. Floating point numbers can't generally represent a decimal number exactly, so you get some rounding errors

[BUGS] BUG #3467: Sum strange behaviour

2007-07-18 Thread Alex
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 (al