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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to