Re: Is indexing broken for bigint columns? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Is indexing broken for bigint columns?
Date
Msg-id 200402250138.31312.peter_e@gmx.net
Whole thread Raw
In response to Re: Is indexing broken for bigint columns?  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
Dann Corbit wrote:
> > Dann Corbit wrote:
> > > http://www.phpbuilder.com/columns/smith20010821.php3?page=3
>
> http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-INT
>
> PostgreSQL is the only database that requires casts to do an index
> lookup.

This issue has been discussed on these mailing lists literally dozens of 
times.  If you're interested in the details, please see the archives.  
Further discussion will hopefully not be necessary, because 7.5 will 
fix it.



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: [GENERAL] select statement against pg_stats returns inconsistent
Next
From: Mike Mascari
Date:
Subject: Re: Is indexing broken for bigint columns?