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/i...TATYPE-NUMERIC

Cordialement,
Jean-Gérard Pailloncy


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

On Wed, Dec 13, 2006 at 03:03:43PM -0000, Jean-Gérard Pailloncy wrote:
I think the cast is binding tighter than the unary minus, so the
above is equivalent to

select -(32768::smallint)

which is why you're getting "smallint out of range." This should work:

select (-32768)::smallint

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On Wed, Dec 13, 2006 at 08:34:38AM -0700, Michael Fuhr wrote:
Indeed it is; see the Operator Precedence table:

http://www.postgresql.org/docs/8.1/i...SQL-PRECEDENCE

--
Michael Fuhr

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

But really conter-intuitive.

Cordialement,
Jean-Gérard Pailloncy


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend