> * Fast case insensitive text search via indexes (function based indexes)
Try to:
create table test (s text);
create index ix_test_s on test(lower(s));
And try select * from test where lower(s) = 'test';
If you made vacuum, and have enough data in the table you will get index
scan. Also you will get index scan for this:
select * from test where lower(s) like 'test%';
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------