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

From Michael Fuhr
Subject Re: BUG #2117: inconsistency in sum
Date
Msg-id 20051215175808.GA44979@winnie.fuhr.org
Whole thread Raw
In response to BUG #2117: inconsistency in sum  ("Adam Kolany" <dr.a.kolany@wp.pl>)
List pgsql-bugs
On Thu, Dec 15, 2005 at 11:03:55AM +0000, Adam Kolany wrote:
> 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)

What data types are wplyw and wydatek?

--
Michael Fuhr

pgsql-bugs by date:

Previous
From: "Jon Keating"
Date:
Subject: BUG #2116: Searching text fields does not work in EUC_JP
Next
From: Tom Lane
Date:
Subject: Re: BUG #2117: inconsistency in sum