Postgres Pro
Downloads
Home   >   mailing lists

Re: Aggregate Function (AVG) not calculated correctly - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Aggregate Function (AVG) not calculated correctly
Date
Msg-id 14495.976030278@sss.pgh.pa.us
Whole thread Raw
In response to Aggregate Function (AVG) not calculated correctly  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> I have included all code needed to prove the bug,

No, you haven't: where are the table declarations?

But I'll take a guess anyway: you declared "distance" as int2, didn't
you?  AVG(int2) currently uses an int2 accumulator, and you're suffering
overflow.  Try "AVG(distance::float8)" instead.

We've changed AVG() to use a numeric accumulator for 7.1, but that
won't help you today.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Aggregate Function (AVG) not calculated correctly
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: createlang requires entering password 4 times