Re: BUG #1626: Minimum documented values aren't accepted for all basic integer types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dennis Vshivkov" <walrus(at)amur(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1626: Minimum documented values aren't accepted for all basic integer types
Date: 2005-04-26 22:03:17
Message-ID: 14621.1114552997@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Dennis Vshivkov" <walrus(at)amur(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ariel E. Carn/Elizabeth Sosa 2005-04-26 22:48:12 BUG #1630: Wrong conversion in to_date() function. See example.
Previous Message mike g 2005-04-26 20:23:50 BUG #1629: subquery IN returns incorrect results