>>>>> "scrappy" == The Hermit Hacker <scrappy(at)hub(dot)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(at)inetspace(dot)com