Re: [HACKERS] Re: bug on aggregate function AVG()

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Jose' Soares" <jose(at)sferacarta(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: bug on aggregate function AVG()
Date: 1998-11-04 06:44:55
Message-ID: 363FF7E7.23EC80EA@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-11-04 07:01:18 Re: [HACKERS] A small problem with the new inet and cidr typesg
Previous Message David Gould 1998-11-04 06:40:32 Re: [HACKERS] Re: Comparisons on NULLs (was Re: A small problem...)