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, 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
