Re: [HACKERS] Re: [QUESTIONS] Error on PostgreSQL agregate SUM() function?? - Mailing list 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