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

From Kevin Murphy
Subject the current scoop on ilike and indexes
Date
Msg-id 6481F9BE-0BFA-11D9-8147-0003930D3626@genome.chop.edu
Whole thread Raw
Responses Re: the current scoop on ilike and indexes
List pgsql-general
I am pretty sure the answer is no, but ... is there any way to get
'ilike' to use an index?  It seems like something that a lot of people
would want to do.  Otherwise, should I just create redundant
case-mapped columns and use 'like'?

Thanks,
Kevin Murphy


pgsql-general by date:

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