Ok I will have a look at how to put it on gborg. Regards Donald Fraser
----- Original Message ----- From: "scott.marlowe" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] > > > > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
