From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Donald Fraser <demolish(at)cwgsy(dot)net> |
Cc: | "[ADMIN]" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Case Insensitive comparison |
Date: | 2003-09-25 17:34:37 |
Message-ID: | Pine.LNX.4.33.0309251134150.18705-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)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(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rhaoni Chiu Pereira | 2003-09-25 17:38:37 | ERROR: tuplestore: write failed |
Previous Message | Donald Fraser | 2003-09-25 17:24:42 | Re: Case Insensitive comparison |