Integer/BigInt Implicit Typing Bug

From: pmcneill(at)berkleemusic(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: Integer/BigInt Implicit Typing Bug
Date: 2004-02-12 14:57:10
Message-ID: 20040212095710.A28214@cbg.berkleemusic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-02-12 15:58:52 Re: Integer/BigInt Implicit Typing Bug
Previous Message Sh A Guru Prasad 2004-02-12 13:04:06 socket error while creating database in windows98