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