Re: best index for ~ ordering? - Mailing list pgsql-sql

On Wed, Mar 07, 2007 at 12:28:57AM -0300, gherzig@fmed.uba.ar wrote:
> Well, im wondering if is possible using LIKE '%blah%', even better would be
> upper/lower(string) like '%blah%',

Your better bet then is either to index lower(string) or better, on
insert convert everything to lower().

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.    --Roger Brinner