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

• ilike not using index. at 2010-06-15 06:53:35 from Darryl Pye

Responses

• Re: ilike not using index. at 2010-06-21 19:39:52 from Kenneth Marshall

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