Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group