Re: [BUGS] BUG #1608: integer negative limit in plpgsql function arguments

2005-04-23 Thread Tom Lane
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

Re: [BUGS] BUG #1608: integer negative limit in plpgsql function arguments

2005-04-20 Thread Tom Lane
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

Re: [BUGS] BUG #1608: integer negative limit in plpgsql function arguments

2005-04-20 Thread Tom Lane
"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

[BUGS] BUG #1608: integer negative limit in plpgsql function arguments

2005-04-20 Thread Paul
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