Re: problem: index on number not honoured

>>>>> "Ilker" == Ilker Egilmez <ilker(at)gate5(dot)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(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375