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

Dann Corbit wrote:

> PostgreSQL is the only database that requires casts to do an index
> lookup.

Possibly (quite probably) true, but you don't show any evidence that 
SQL*Server, Oracle, or MySQL uses indexes either. Like I said 
before, Tom (of course) already has a fix is already in the 
development branch:


http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=29832.1068682253%40sss.pgh.pa.us&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26scoring%3Dd%26q%3Dbigint%2Bindex%2Bhackers%2Bpostgresql

> 
> This is SQL*Server syntax:
> ==============================================================
...
> select * from foo where bar = 1
...
> This is Oracle syntax:
> ==============================================================
> SQL> select * from foo where bar = 1;
...
> mysql> select * from foo where bar = 1;

Mike Mascari