On Sat, Jan 30, 2010 at 4:44 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
It's here:On Fri, Jan 29, 2010 at 7:40 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
> On Fri, Jan 29, 2010 at 2:52 PM, Moe <mohamed5432154321@xxxxxxxxx> 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.
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.
Sorry, I forgot I posted the message. What I mean was that a query select * from where email = ? could match on both upper and lower case emails, such myEmail@xxxxxxxxxxx or myemail@xxxxxxxxxxx
I know I can use the lower(...) function but this is not an option when using hibernate.
MySql is by default case insensitive, I just figured there'd be an option to turn it on in PG as well.
What about 9.0 ? How is that going to be offered ?
For now I just normalized all emails to lower cased, and changed so that they are always saved in lower.. but there are other columns that are likely to need similar mathing ( firstname, lastname, address ... ) where lowering is not an option, and where storing in a separate column is really ugly. The like possibility is probably just slow.
Sincerely / Moe
