| From: | "Alex" <AVShutko(at)mail(dot)khstu(dot)ru> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #3467: Sum strange behaviour |
| Date: | 2007-07-18 09:26:46 |
| Message-ID: | 200707180926.l6I9Qkgi089096@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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 ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2007-07-18 09:50:10 | Re: BUG #3467: Sum strange behaviour |
| Previous Message | Eugene Gershnik | 2007-07-18 03:19:20 | BUG #3462: pg_ctl error output cannot be redirected |