Re: LIKE should use index when condition doesn't include - Mailing list 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