Re: BUG #4920: need case-insensitive searches

On Tue, Jul 14, 2009 at 01:28:30PM +0000, Michael Gould wrote:
> I can see why people use case sensitive searches but it would be nice if
> there was either a setup option in the init program or a encoding and locale
> that would allow for case insenstive searches without having to use a
> non-standard Ilike search. In out database for example, we have no text
> fields that need a case sensitive index or search.

In 8.4, the citext module provides you a case-insensitive data type. In
earlier versions, you might store uppper(text_field) in the database instead
of or in addition to the original text_field value.

http://www.postgresql.org/docs/current/static/citext.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com