Re: Case Insensitive comparison

Any chance of those libs being put somewhere public (gborg.postgresql.org
or something?)

On Thu, 25 Sep 2003, Donald Fraser wrote:

>
> ----- Original Message -----
> From: George A.J
> To: pgsql-admin@postgresql.org
> Sent: Thursday, September 25, 2003 4:39 AM
> Subject: [ADMIN] Case Insensitive comparison
>
>
> >hai
> >
> >i am using postgresql 7.3.x. I am converting a database in MS SQL server to
> PostgreSQL.
> >
> >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
>
> I have created a text data type which is case-insensitive. Everything is
> identical to type text in all other respects. If you would like I can email you
> the library files to make and install it.
>
> Regards
> Donald Fraser
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>