the current scoop on ilike and indexes

From: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: the current scoop on ilike and indexes
Date: 2004-09-21 18:16:44
Message-ID: 6481F9BE-0BFA-11D9-8147-0003930D3626@genome.chop.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reynard Hilman 2004-09-21 18:40:35 Re: abnormal data grow
Previous Message Chris Travers 2004-09-21 18:11:33 Re: Stored Procedures