Re: case insensitive like searches

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Mark Dueck <mark(at)dueck(dot)bz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: case insensitive like searches
Date: 2009-04-15 13:05:41
Message-ID: 20090415130541.GI18845@it.is.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message DM 2009-04-15 17:29:48 Standards for Postgres Installation Question?
Previous Message Benjamin Minshall 2009-04-14 18:53:10 Backup only changed databases