Wow! postgresql is a miracle! :-)
I'm starting to wonder why anybody would want to use Oracle...
Alexander Jerusalem
ajeru@gmx.net
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: dyp@perchine.com
>HomePage: http://www.perchine.com/dyp/
>FidoNet: 2:5000/120.5
>----------------------------------