Re: Case Insensitive comparison

On Wed, 24 Sep 2003, George A.J wrote:

> The main problems i am facing is that in sql server the text comparisons
> are case insensitive. how can i compare text case insensitive in
> postgresql without using an upper() or lower() function in both sides
> (=). Is there any option to set in postgresql?
>
> Is there any problem in overriding the = operator that compare text. ie
> droping the current operator = and creating a new = operator(text,text).
> Does the existing = operator is using internally by postgres for some
> porpose. please help

Well, you'd really want to change all the comparison operators because
otherwise I think indexes would be screwy and I don't know off hand if
this will cause problems, but I can imagine that it might, if only on
queries from clients and such on the system catalogs.

One other option is to find or make a case insensitive collating locale
for your operating system and use that when initializing the database.
I've never tried so I can't say whether that'll have its own problems.