Re: BUG #5484: sum() bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sergey" <viras(at)yandex(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5484: sum() bug
Date: 2010-05-30 17:43:57
Message-ID: 1778.1275241437@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Sergey" <viras(at)yandex(dot)ru> writes:
> 8849.15+6464.57=15313.72
> But sum()=15313.7

You did not show what datatype you're summing, but if the column is
float4 this result wouldn't be surprising. float4 is only good
to about six decimal digits.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-05-30 17:54:14 Re: BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery
Previous Message Daniele Varrazzo 2010-05-30 16:59:36 Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation