Re: LIKE should use index when condition doesn't include

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: LIKE should use index when condition doesn't include
Date: 2004-03-31 00:56:09
Message-ID: 200403301656.09664.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Palle,

> But what about ILIKE. It does not take advantage of indices built with
> lower():

Nope. If you want to use a functional index, you'll need to use the function
when you call the query. ILIKE is not somehow aware that it is equivalent
to lower().

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Palle Girgensohn 2004-03-31 01:04:40 Re: LIKE should use index when condition doesn't include
Previous Message Palle Girgensohn 2004-03-31 00:28:31 Re: LIKE should use index when condition doesn't include