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

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

From
"Meskes, Michael"
Date:
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>
>
>
>