On Fri, Jan 29, 2010 at 7:40 PM, Scott Marlowe <[email protected]> wrote: > On Fri, Jan 29, 2010 at 2:52 PM, Moe <[email protected]> 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. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
