Re: Integer/BigInt Implicit Typing Bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pmcneill(at)berkleemusic(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Integer/BigInt Implicit Typing Bug
Date: 2004-02-12 15:58:52
Message-ID: 4606.1076601532@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pmcneill(at)berkleemusic(dot)com writes:
> In the 7.4.1 release, I've found that it implicitly types INT_MIN,
> -2147483648, as a 64-bit integer instead of a 32-bit integer.

This is not a bug, and the reason is that "-" is a separate operator.
"2147483648" is an int8 constant.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Javier Carlos 2004-02-12 18:46:27 Problem with datatype REAL using the = (EQUAL) operator
Previous Message pmcneill 2004-02-12 14:57:10 Integer/BigInt Implicit Typing Bug