Skip site navigation (1) Skip section navigation (2)

BUG #2117: inconsistency in sum

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-12-15 17:58:08
Subject: Re: BUG #2117: inconsistency in sum
Previous:From: Tom LaneDate: 2005-12-15 06:25:55
Subject: Re: BUG #2113: PostgreSQL hangs after running for 2 days

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group