Postgres Pro
Downloads
Home   >   mailing lists

Re: ilike not using index. - Mailing list pgsql-novice

From Tom Lane
Subject Re: ilike not using index.
Date
Msg-id 16763.1277148967@sss.pgh.pa.us
Whole thread Raw
In response to ilike not using index.  (Darryl Pye <darrylpye@hotmail.com>)
Responses Re: ilike not using index.  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-novice
Tree view 
Darryl Pye <darrylpye@hotmail.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
indexdoesn'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

pgsql-novice by date:

Previous
From: Darryl Pye
Date:
Subject: ilike not using index.
Next
From: Kenneth Marshall
Date:
Subject: Re: ilike not using index.