Postgres Pro
Downloads
Home   >   mailing lists

Re: select avg() and sum() returns false value - Mailing list pgsql-bugs

From Tom Lane
Subject Re: select avg() and sum() returns false value
Date
Msg-id 25267.990224311@sss.pgh.pa.us
Whole thread Raw
In response to select avg() and sum() returns false value  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> I don't know, if it's my fault, but when I sum up several thousands
> of positive entries in a column (the column is an int2 field), I get a negative(!) value.

Use Postgres 7.1.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: select avg() and sum() returns false value
Next
From: Thomas Lockhart
Date:
Subject: Re: Problems with avg on interval data type