From: | "mirek" <mirek(at)mascort(dot)com(dot)pl> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3991: pgsql function sum() |
Date: | 2008-02-26 10:25:34 |
Message-ID: | 200802261025.m1QAPYcS093863@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
With regards
Mirek
From | Date | Subject | |
---|---|---|---|
Next Message | spol@mail.ru | 2008-02-26 11:25:19 | help me plz with 2 postgres users |
Previous Message | Magnus Hagander | 2008-02-26 09:29:17 | Re: BUG #3985: select command not working |