Horton

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

Kent S. Gordon <kgor@inetspace.com>

View thread
From: "Kent S. Gordon" <kgor@inetspace.com>
To: scrappy@hub.org
Cc: lockhart@alumni.caltech.edu, sferac@bo.nettuno.it, hackers@postgreSQL.org
Date: 1998-02-11T19:27:54Z
Lists: pgsql-hackers 
>>>>> "scrappy" == The Hermit Hacker <scrappy@hub.org> writes:

    > 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

Oracle does all math in base 100 so it is not the same as using
integer.

    SQL>

Kent S. Gordon
Architect
iNetSpace Co.
voice: (972)851-3494 fax:(972)702-0384 e-mail:kgor@inetspace.com