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. Here's a test
case:

select "bit"(-2147483647);
bit
----------------------------------
10000000000000000000000000000001

select "bit"(-2147483648 + 1);
bit
------------------------------------------------------------------
11111111111111111111111111111111100000000000000000 00000000000001

-Patrick McNeill

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

pmcneill (AT) berkleemusic (DOT) com writes:
This is not a bug, and the reason is that "-" is a separate operator.
"2147483648" is an int8 constant.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly