| From: | "Adam Kolany" <dr(dot)a(dot)kolany(at)wp(dot)pl> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2117: inconsistency in sum |
| Date: | 2005-12-15 11:03:55 |
| Message-ID: | 20051215110355.50EEAF0B3F@svr2.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2117
Logged by: Adam Kolany
Email address: dr(dot)a(dot)kolany(at)wp(dot)pl
PostgreSQL version: 8.0.1
Operating system: Linux, SuSe 9.2
Description: inconsistency in sum
Details:
can you explain this?
======================================================
stoff=> select sum(wplyw),sum(wydatek), sum(wplyw)-sum(wydatek) from
rachunki where okres<6;
sum | sum | ?column?
-------+---------+----------
73745 | 6712.55 | 67032.5
(1 row)
stoff=>
======================================================
in real, the 'sum(wplyw)' should be: 73745,05
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-12-15 17:58:08 | Re: BUG #2117: inconsistency in sum |
| Previous Message | Tom Lane | 2005-12-15 06:25:55 | Re: BUG #2113: PostgreSQL hangs after running for 2 days |