Wow! postgresql is a miracle! :-) I'm starting to wonder why anybody would want to use Oracle... Alexander Jerusalem [EMAIL PROTECTED] vknn At 14:02 24.01.01, Denis Perchine wrote: > > * 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: [EMAIL PROTECTED] >HomePage: http://www.perchine.com/dyp/ >FidoNet: 2:5000/120.5 >----------------------------------
