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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
