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 4: Don't 'kill -9' the postmaster
