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
pgsql-novice by date
|Next:||From: Kenneth Marshall||Date: 2010-06-21 19:39:52|
|Subject: Re: ilike not using index.|
|Previous:||From: Mladen Gogala||Date: 2010-06-18 20:12:28|
|Subject: Re: Runnning operating system commands from an SPL|