Re: Possible to set postgres in case insensitive mode ?

On Fri, Jan 29, 2010 at 7:40 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Fri, Jan 29, 2010 at 2:52 PM, Moe <mohamed5432154321@gmail.com> wrote:
>> Is it possible to set postgres in case insensitive mode ?
>>
>> If so, how?
>
> What part, exactly, do you want to be case insensitive?  I assume you
> mean a text / varchar type?  Look for citext, I believe it's a contrib
> module, until 9.0 is out, which will include it natively.

It's here:
http://pgfoundry.org/projects/citext/
But it doesn't work in 8.3 or 8.4, only 8.2 and before.  So either run
that or wait for 9.0 I guess.