Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Murphy
Subject Re: the current scoop on ilike and indexes
Date
Msg-id 2F88BCFF-0C12-11D9-8147-0003930D3626@genome.chop.edu
Whole thread Raw
In response to Re: the current scoop on ilike and indexes  (Thomas F.O'Connell <tfo@sitening.com>)
Responses Re: the current scoop on ilike and indexes  (Thomas F.O'Connell <tfo@sitening.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Prioritizing queries
Next
From: Thomas F.O'Connell
Date:
Subject: Re: the current scoop on ilike and indexes