Thread: 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
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
----- 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
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 >
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 > > > >
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.