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

Re: BUG #3991: pgsql function sum()

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: mirek <mirek(at)mascort(dot)com(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3991: pgsql function sum()
Date: 2008-02-26 12:55:19
Message-ID: 47C40C37.2090501@sun.com (view raw or flat)
Thread:
Lists: pgsql-bugs
mirek napsal(a):
> The following bug has been logged online:
> 
> Bug reference:      3991
> Logged by:          mirek
> Email address:      mirek(at)mascort(dot)com(dot)pl
> PostgreSQL version: 8.2.4
> Operating system:   Linux fedora(for work) and windows(for development)
> Description:        pgsql function sum()
> Details: 
> 
> I saw a very strange behavior when i used function SUM() in query (used
> inside pg function), query:
> 
> select magazyn, ciag, numer, datawp, vat, sum(wnetto-wnettop) as wn,
> sum(wvat-wvatp) as wv, sum(wbrutto-wbruttop) as wb from vzk_pozycjezinfo
> where magazyn = $1 and ciag = $2 and numer = $3 and datawp = $4
> group by magazyn, ciag, numer, datawp, vat 
> order by magazyn, ciag, numer, datawp, vat 
> 
> vzk_pozycjezinfo is view
> 
> problem is in: sum(wvat-wvatp) where field in view wvat = 33.08 and wvatp =
> 36.09 
> Result is -3.01000000000001 
> 
> If I ask postgres manualy: select sum(33.08 - 36.09)
> result is ok -3.01 
> 
> Now I fix it with round function but i think that is a bug.

How are wv and wb attribute defined? Are they number or flout/double?


		Zdenek

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-02-26 15:45:08
Subject: Re: BUG #3991: pgsql function sum()
Previous:From: spol@mail.ruDate: 2008-02-26 11:25:19
Subject: help me plz with 2 postgres users

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