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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Paul" <paul(at)allinea(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1608: integer negative limit in plpgsql function arguments
Date: 2005-04-20 15:10:13
Message-ID: 27256.1114009813@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Paul" <paul(at)allinea(dot)com> 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 lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-04-20 15:57:37 Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Previous Message Oliver Siegmar 2005-04-20 15:04:32 BUG #1609: Bug in interval datatype for 64 Bit timestamps