Thread: Case Insensitive comparison

Case Insensitive comparison

From
"George A.J"
Date:
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
 
Another problem is in creating function...
How can i create a function that accept and return any type. the type "any" is not allowing as parameter or return type. Is it possible? i want to create a function similar to NULLIF().
 
jinujose
 


Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

Re: Case Insensitive comparison

From
"Donald Fraser"
Date:
----- 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


Re: Case Insensitive comparison

From
"scott.marlowe"
Date:
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
>


Re: Case Insensitive comparison

From
"Donald Fraser"
Date:
Ok I will have a look at how to put it on gborg.

Regards
Donald Fraser

----- Original Message -----
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: "Donald Fraser" <demolish@cwgsy.net>
Cc: "[ADMIN]" <pgsql-admin@postgresql.org>
Sent: Thursday, September 25, 2003 6:34 PM
Subject: Re: [ADMIN] 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
> >
>
>


Re: Case Insensitive comparison

From
"Donald Fraser"
Date:
Ok I have started the process... I now have to wait for GBorg to get back to me
on whether they want it on the site our not.

Regards
Donald Fraser

----- Original Message -----
From: "Jamie Lawrence" <jal@jal.org>
To: "Donald Fraser" <demolish@cwgsy.net>
Sent: Thursday, September 25, 2003 7:04 PM
Subject: Re: [ADMIN] Case Insensitive comparison


> On Thu, 25 Sep 2003, Donald Fraser wrote:
>
> > Ok I will have a look at how to put it on gborg.
>
> When you do, can you point the list at it, or email me what you've done?
> I'd love to have this availale - I've had to write some creepy, slow
> code to simulate it. I haven't been able to think of a way to write
> something that would do this without writing something in C, which I
> haven't been willing to do yet.
>
> Thank you!
>
> -j
>
> > Regards
> > Donald Fraser
> [...]
> > > Any chance of those libs being put somewhere public (gborg.postgresql.org
> > > or something?)
> > >
> > > On Thu, 25 Sep 2003, Donald Fraser wrote:
> [...]
> > > > 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.