Re: case insensitive like searches

In 8.4 there is a citext contrib module that should do the
trick.

Cheers,
Ken

On Mon, Apr 13, 2009 at 09:59:11AM -0600, Mark Dueck wrote:
> Is there a way to make Postgres do case insensitive like searches? I
> know you can use ilike instead, but I don't have control of the
> software. Is there a plan to enable this in the future?
>
> Can I recompile Postgres to make like searches do the same as ilike, or
> is it easier to create a new character encoding that will be case
> insensitive?
>
> Thanks,
> Mark
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>