I wrote:
> You're right, we do cheat a little on negative numeric constants --- I
> had forgotten about the doNegate() hack in gram.y. We could conceivably
> fix it to cheat some more. Specifically it looks like make_const() in
> parse_node.c could check for the possibility that a T_Float fits in
Paul Edwards <[EMAIL PROTECTED]> writes:
> Also, just as an experiment I tried the minimum limit for bigint (see
> attached file). It seems that I do not need to cast for negative limit
> which is inconsistent since 9223372036854775808 is not a bigint (when
> -9223372036854775808 is). Therefore t
"Paul" <[EMAIL PROTECTED]> writes:
> -- this doesn't work (and I think it should!)
> SELECT print_test_id(-2147483648);
"2147483648" isn't an integer constant; it's int8, and therefore so
is the result of the minus operator. Sorry, this isn't going to
change.
regards, tom
The following bug has been logged online:
Bug reference: 1608
Logged by: Paul
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.2
Operating system: Gentoo and Fedora Core 3
Description:integer negative limit in plpgsql function arguments
Details:
The script b