Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1626: Minimum documented values aren't accepted for all basic integer types - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1626: Minimum documented values aren't accepted for all basic integer types
Date
Msg-id 14621.1114552997@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1626: Minimum documented values aren't accepted for all basic integer types  ("Dennis Vshivkov" <walrus@amur.ru>)
List pgsql-bugs
Tree view 
"Dennis Vshivkov" <walrus@amur.ru> writes:
> # SELECT -32768::SMALLINT;
> ERROR:  smallint out of range

Not a bug, because that is read as "-(32768::SMALLINT)", per the
documented operator precedence.  Try (-32768)::SMALLINT.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Juan Villa"
Date:
Subject: BUG #1625: INTALL PROBLEM
Next
From: "Lasantha Kularatne"
Date:
Subject: Re: BUG #1625: INTALL PROBLEM