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