"Dennis Vshivkov" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq