On Wed, Dec 13, 2006 at 08:34:38AM -0700, Michael Fuhr wrote: > On Wed, Dec 13, 2006 at 03:03:43PM -0000, Jean-Gérard Pailloncy wrote: > > On PostgreSQL 8.1.2 > > select -32768::smallint > > throws the error > > ERROR: smallint out of range > > I think the cast is binding tighter than the unary minus,
Indeed it is; see the Operator Precedence table: http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-PRECEDENCE -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
