"Carlo Stonebanks" <stonec.register@xxxxxxxxxxxx> 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
