Case Insensitive comparison
Case Insensitive comparison
От:
"George A.J" <jinujosein@yahoo.com>
Дата:
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
От:
"Donald Fraser" <demolish@cwgsy.net>
Дата:
----- 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
От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
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
От:
"Donald Fraser" <demolish@cwgsy.net>
Дата:
Ok I will have a look at how to put it on gborg. Regards Donald Fraser ----- Original Message ----- From: "scott.marlowe" To: "Donald Fraser" Cc: "[ADMIN]" 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
От:
"Donald Fraser" <demolish@cwgsy.net>
Дата:
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" To: "Donald Fraser" 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.