BUG #2117: inconsistency in sum - Mailing list pgsql-bugs

From Adam Kolany
Subject BUG #2117: inconsistency in sum
Date
Msg-id 20051215110355.50EEAF0B3F@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #2117: inconsistency in sum
Re: BUG #2117: inconsistency in sum
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2117
Logged by:          Adam Kolany
Email address:      dr.a.kolany@wp.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2113: PostgreSQL hangs after running for 2 days
Next
From: "Jon Keating"
Date:
Subject: BUG #2116: Searching text fields does not work in EUC_JP