Postgres Pro
Downloads
Home   >   mailing lists

indexes for ILIKE - Mailing list pgsql-general

From Ilja Golshtein
Subject indexes for ILIKE
Date
Msg-id 43F07C9E.000003.12156@ariel.yandex.ru
Whole thread Raw
Responses Re: indexes for ILIKE  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Hello!

Is there any way to use an index to pick up text field
start from a substring?
I need to ignore case of characters and encoding I use is UTF-8.

I am aware of text_pattern_ops and stuff, though
FAQ says ILIKE does not use indexes.

Thanks.

--
Best regards
Ilja Golshtein

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: r trim of characters other than space
Next
From: Martijn van Oosterhout
Date:
Subject: Re: indexes for ILIKE