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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to