Re: the current scoop on ilike and indexes - Mailing list pgsql-general

On Sep 21, 2004, at 4:52 PM, Thomas F.O'Connell wrote:
> You can use an index on an expression like "lower( col ) LIKE ... " as
> long as the LIKE expression is left-anchored. See

Yes, I know that already.  I wasn't talking about LIKE; I was talking
about ILIKE.  The data in the column is mixed-case.

-Kevin