Re: Using bigint needs explicit cast to use the index - Mailing list pgsql-performance

Andrew Sullivan wrote:
> "Intended", no.  "Expected", yes.  This topic has had the best
> Postgres minds work on it, and so far nobody's come up with a
> solution.

Actually, this has already been fixed in CVS HEAD (as I mentioned in
this thread yesterday). To wit:

nconway=# create table t1 (a int8);
CREATE TABLE
nconway=# create index t1_a_idx on t1 (a);
CREATE INDEX
nconway=# explain select * from t1 where a = 5;
                              QUERY PLAN
--------------------------------------------------------------------
  Index Scan using t1_a_idx on t1  (cost=0.00..17.07 rows=5 width=8)
    Index Cond: (a = 5)
(2 rows)
nconway=# select version();
                                       version
------------------------------------------------------------------------------------
  PostgreSQL 7.5devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.3 (Debian)
(1 row)

-Neil