Re: the current scoop on ilike and indexes

From: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
To: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: the current scoop on ilike and indexes
Date: 2004-09-21 21:07:03
Message-ID: 2F88BCFF-0C12-11D9-8147-0003930D3626@genome.chop.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F.O'Connell 2004-09-21 21:17:12 Re: the current scoop on ilike and indexes
Previous Message Steve Atkins 2004-09-21 21:04:26 Re: Prioritizing queries