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: 1778.1275241437@sss.pgh.pa.us (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group