Horton

Re: [HACKERS] Re: [QUESTIONS] Error on PostgreSQL agregate SUM() function??

Marc G. Fournier <scrappy@hub.org>

View thread
From: The Hermit Hacker <scrappy@hub.org>
To: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Cc: sferac@bo.nettuno.it, Postgres Hackers List <hackers@postgreSQL.org>
Date: 1998-02-11T15:14:15Z
Lists: pgsql-hackers 
On Wed, 11 Feb 1998, Thomas G. Lockhart wrote:

> > PostgreSQL SUMs population column given -1523690296 (overflow)
> > While SOLID and MySQL gives 2771277000.
> >
> > Who are right PostgreSQL or SOLID and MySQL ?
> 
> Duh.

Just to add in here...Oracle:

SQL> select sum(population) from nations;

SUM(POPULATION)
---------------
     2771277000

SQL>