Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5484: sum() bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5484: sum() bug
Date
Msg-id 1778.1275241437@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5484: sum() bug  ("Sergey" <viras@yandex.ru>)
Responses Re: BUG #5484: sum() bug  (viras <viras@yandex.ru>)
List pgsql-bugs
Tree view 
"Sergey" <viras@yandex.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

pgsql-bugs by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation
Next
From: Tom Lane
Date:
Subject: Re: BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery