Request a Demo
Home   >   mailing lists

Re: [HACKERS] Re: bug on aggregate function AVG() - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Re: bug on aggregate function AVG()
Date
Msg-id [email protected]
Whole thread Raw
In response to bug on aggregate function AVG()  ("Jose' Soares" <[email protected]>)
List pgsql-hackers
Tree view 
> > prova=> select avg(int_2), avg(int_4), avg(int_8) from a;
> The same on SUM():

Sure. For some reason, on most platforms integers are allowed to
overflow in Postgres. Of course, both SUM() and AVG() take a running
sum, and once they overflow you are hosed...
                   - Tom

pgsql-hackers by date:

Previous
From: [email protected] (David Gould)
Date:
Subject: Re: [HACKERS] Re: Comparisons on NULLs (was Re: A small problem...)
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] A small problem with the new inet and cidr typesg