8.1.2 -32768::smallint

From: Jean-Gérard Pailloncy <jg(at)rilk(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 8.1.2 -32768::smallint
Date: 2006-12-13 15:03:43
Message-ID: 57112.82.239.202.91.1166022223.squirrel@webmail.rilk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2006-12-13 15:34:38 Re: 8.1.2 -32768::smallint
Previous Message Gergely CZUCZY 2006-12-13 12:32:37 fkey+inheritance issue