Skip site navigation (1) Skip section navigation (2)

Re: Integer/BigInt Implicit Typing Bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pmcneill(at)berkleemusic(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Integer/BigInt Implicit Typing Bug
Date: 2004-02-12 15:58:52
Message-ID: 4606.1076601532@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pmcneill(at)berkleemusic(dot)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

In response to

pgsql-bugs by date

Next:From: Javier CarlosDate: 2004-02-12 18:46:27
Subject: Problem with datatype REAL using the = (EQUAL) operator
Previous:From: pmcneillDate: 2004-02-12 14:57:10
Subject: Integer/BigInt Implicit Typing Bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group