On Fri, Jan 29, 2010 at 7:40 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Fri, Jan 29, 2010 at 2:52 PM, Moe <mohamed5432154321(at)gmail(dot)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.