Re: ilike not using index.

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