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

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: sferac(at)bo(dot)nettuno(dot)it, Postgres Hackers List <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Re: [QUESTIONS] Error on PostgreSQL agregate SUM() function??
Date: 1998-02-11 15:14:15
Message-ID: Pine.NEB.3.95.980211101353.13163L-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-02-11 15:27:59 Re: [HACKERS] Some cleanups/enhancements
Previous Message The Hermit Hacker 1998-02-11 14:47:41 RE: [HACKERS] info files