Re: ilike not using index.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darryl Pye <darrylpye(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ilike not using index.
Date: 2010-06-21 19:36:07
Message-ID: 16763.1277148967@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Darryl Pye <darrylpye(at)hotmail(dot)com> writes:
> Index was working correctly in 8.4,I have upgraded to version 9 as I require some of the new features and now the index doesn't work.

No version of Postgres has ever been able to use an index for ILIKE.

You might consider creating an index on lower(full_name) and then
querying WHERE lower(full_name) LIKE whatever.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kenneth Marshall 2010-06-21 19:39:52 Re: ilike not using index.
Previous Message Mladen Gogala 2010-06-18 20:12:28 Re: Runnning operating system commands from an SPL