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

Re: BUG #2117: inconsistency in sum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Adam Kolany" <dr(dot)a(dot)kolany(at)wp(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2117: inconsistency in sum
Date: 2005-12-15 18:00:30
Message-ID: 15751.1134669630@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Adam Kolany" <dr(dot)a(dot)kolany(at)wp(dot)pl> writes:
> 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)

Seems odd, but you haven't provided nearly enough information to let
anyone else reproduce the problem.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-12-15 18:04:14
Subject: Re: BUG #2116: Searching text fields does not work in EUC_JP
Previous:From: Michael FuhrDate: 2005-12-15 17:58:08
Subject: Re: BUG #2117: inconsistency in sum

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