Thread

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

Michael Meskes <meskes@topsystem.de> — 1998-02-11T15:39:07Z

Oracle doesn't count as they don't have integers etc. They only use a
selfdesigned number datatype that is able to handle that kind of
numbers, too.

Michael

--
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10

> -----Original Message-----
> From:	The Hermit Hacker [SMTP:scrappy@hub.org]
> Sent:	Wednesday, February 11, 1998 4:14 PM
> To:	Thomas G. Lockhart
> Cc:	sferac@bo.nettuno.it; Postgres Hackers List
> Subject:	Re: [HACKERS] Re: [QUESTIONS] Error on PostgreSQL
> agregate SUM() function??
> 
> 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> 
> 
> 
>