int4 range

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: int4 range
Date: 1999-01-04 14:12:58
Message-ID: 11634.990104@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I supposed the int4 range was from -2147483648 to +2147483647 but I
have the following message trying to update an int4 column:

prova=> update t set i=-2147483648;
NOTICE: Integer input '2147483648' is out of range; promoted to float
UPDATE 1

The column was updated any way, but I don't understand the message.

prova=> update t set i=-2147483647;
UPDATE 1

PS: I'm using v6.4 on Linux.

-Jose'-

Browse pgsql-hackers by date

  From Date Subject
Next Message Sferacarta Software 1999-01-04 14:14:30 money bug
Previous Message orion.SAPserv.Hamburg.dsh.de!wieck 1999-01-04 13:56:04 Re: [HACKERS] a test