Thread

1. Is indexing broken for bigint columns?

   Dann Corbit <dcorbit@connx.com> — 2004-02-24T23:03:05Z

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

2. Re: Is indexing broken for bigint columns?

   Mike Mascari <mascarm@mascari.com> — 2004-02-24T23:26:36Z

   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
   
   
   
   
   
   

3. Re: Is indexing broken for bigint columns?

   Peter Eisentraut <peter_e@gmx.net> — 2004-02-24T23:38:23Z

   Dann Corbit wrote:
   > http://www.phpbuilder.com/columns/smith20010821.php3?page=3
   
   http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-INT