Postgres Pro
Downloads
Home   >   mailing lists

8.1.2 -32768::smallint - Mailing list pgsql-bugs

From Jean-Gérard Pailloncy
Subject 8.1.2 -32768::smallint
Date
Msg-id 57112.82.239.202.91.1166022223.squirrel@webmail.rilk.com
Whole thread Raw
Responses Re: 8.1.2 -32768::smallint  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Tree view 
Hi,

On PostgreSQL 8.1.2
select -32768::smallint
throws the error
ERROR:  smallint out of range

select -32767::smallint
is OK.

The documentation states that -32768 is OK.
http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-NUMERIC

Cordialement,
Jean-Gérard Pailloncy

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: postgresql installation on centOS not working
Next
From: Michael Fuhr
Date:
Subject: Re: 8.1.2 -32768::smallint