>>>>> "Ilker" == Ilker Egilmez <ilker@gate5.de> writes:
Ilker> an index on a table column of any number type only gets honoured if you Ilker> query it like a string,
e.g.
Ilker> create table t1 ( n int2 ) ;
Ilker> create index t1n on t1 (n) ;
Ilker> explain select * from t1 where n = 1 ;
Ilker> -- Seq Scan on t1 (cost=0.00..22.50 rows=10 width=2)
Ilker> explain select * from t1 where n = '1' ;
Ilker> -- Index Scan using t1n on t1 (cost=0.00..8.14 rows=10 width=2)
Two questions: have you run vacuum analyze on the table? have you
submitted a bug report?
roland
-- PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland@rlenter.com 76-15 113th Street, Apt 3B
roland@astrofoto.org Forest Hills, NY 11375