BUG #3467: Sum strange behaviour - Mailing list pgsql-bugs

From Alex
Subject BUG #3467: Sum strange behaviour
Date
Msg-id 200707180926.l6I9Qkgi089096@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3467: Sum strange behaviour  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      3467
Logged by:          Alex
Email address:      AVShutko@mail.khstu.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 ?

pgsql-bugs by date:

Previous
From: "Eugene Gershnik"
Date:
Subject: BUG #3462: pg_ctl error output cannot be redirected
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3467: Sum strange behaviour