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

From pmcneill@berkleemusic.com
Subject Integer/BigInt Implicit Typing Bug
Date
Msg-id 20040212095710.A28214@cbg.berkleemusic.com
Whole thread Raw
Responses Re: Integer/BigInt Implicit Typing Bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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
------------------------------------------------------------------
 1111111111111111111111111111111110000000000000000000000000000001

-Patrick McNeill

pgsql-bugs by date:

Previous
From: Sh A Guru Prasad
Date:
Subject: socket error while creating database in windows98
Next
From: Tom Lane
Date:
Subject: Re: Integer/BigInt Implicit Typing Bug