Re: best index for ~ ordering?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: best index for ~ ordering?
Date: 2007-03-07 18:32:24
Message-ID: 20070307183224.GC19042@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Mar 07, 2007 at 12:28:57AM -0300, gherzig(at)fmed(dot)uba(dot)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(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Bartunov 2007-03-07 19:02:25 Re: tesearch2 question
Previous Message Sumeet 2007-03-07 15:46:07 tesearch2 question