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

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: (view raw, whole thread or download thread mbox)
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


pgsql-bugs by date

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

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