Postgres Pro
Downloads
Home   >   mailing lists

Re: Integer/BigInt Implicit Typing Bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Integer/BigInt Implicit Typing Bug
Date
Msg-id 4606.1076601532@sss.pgh.pa.us
Whole thread Raw
In response to Integer/BigInt Implicit Typing Bug  (pmcneill@berkleemusic.com)
List pgsql-bugs
Tree view 
pmcneill@berkleemusic.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

pgsql-bugs by date:

Previous
From: pmcneill@berkleemusic.com
Date:
Subject: Integer/BigInt Implicit Typing Bug
Next
From: "SZŰCS Gábor"
Date:
Subject: 7.4 aggregate OR TRUE yields strange results