http://www.phpbuilder.com/columns/smith20010821.php3?page=3 
 

Message


http://www.phpbuilder.com/columns/smith20010821.php3?page=3
Tue, 24 Feb 2004 15:03:05 -0800
"Dann Corbit" <DCorbit@connx.com>
Is indexing broken for bigint columns?
Dann Corbit wrote:
> http://www.phpbuilder.com/columns/smith20010821.php3?page=3
>  

bigint indexes work fine. The queries probably referenced 32-bit 
integer constants that were neither quoted nor CAST. I always start 
bigint sequences at 5 billion. This ensures that client applications 
aren't assuming 32-bit quantities that will break once ~4.2 billion 
is reached and I get index scans without quoting or casting free. 
But IIRC there's a change in the development tree to jettison the 
requirement for quoting/casting...


Mike Mascari





Tue, 24 Feb 2004 18:26:36 -0500
Mike Mascari <mascarm@mascari.com>
Re: Is indexing broken for bigint columns?
Dann Corbit wrote:
> http://www.phpbuilder.com/columns/smith20010821.php3?page=3

http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-INT


Wed, 25 Feb 2004 00:38:23 +0100
Peter Eisentraut <peter_e@gmx.net>
Re: Is indexing broken for bigint columns?