| 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
| 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 |