Re: ilike not using index.

On Mon, Jun 21, 2010 at 03:36:07PM -0400, Tom Lane wrote:
> 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
>

Would citext support this?

Regards,
Ken