"Carlo Stonebanks" <[EMAIL PROTECTED]> writes: > But is there any way to create an index expression that will help with: > where foo like '%bar%'?
If you are concerned about that, what you are probably really looking for is full-text indexing. See contrib/tsearch2 for our current best answer to that. regards, tom lane ---------------------------(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