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
>
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 |