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

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(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)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(at)hub(dot)org]
> Sent: Wednesday, February 11, 1998 4:14 PM
> To: Thomas G. Lockhart
> Cc: sferac(at)bo(dot)nettuno(dot)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>
>
>
>