X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 9B6B9D1B525
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 25 Sep 2003 03:36:23 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 49212-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 25 Sep 2003 00:35:52 -0300 (ADT)
Received: from web14915.mail.yahoo.com (web14915.mail.yahoo.com
	[216.136.225.228])
	by svr1.postgresql.org (Postfix) with SMTP id 4750ED1B527
	for <pgsql-sql@postgresql.org>; Thu, 25 Sep 2003 00:35:51 -0300 (ADT)
Message-ID: <20030925033550.35699.qmail@web14915.mail.yahoo.com>
Received: from [202.9.168.87] by web14915.mail.yahoo.com via HTTP;
	Wed, 24 Sep 2003 20:35:50 PDT
Date: Wed, 24 Sep 2003 20:35:50 -0700 (PDT)
From: "George A.J" <jinujosein@yahoo.com>
Subject: Case Insensitive comparison
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1735026683-1064460950=:34670"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/290
X-Sequence-Number: 15268

--0-1735026683-1064460950=:34670
Content-Type: text/plain; charset=us-ascii

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
--0-1735026683-1064460950=:34670
Content-Type: text/html; charset=us-ascii

<DIV>hai</DIV>
<DIV>&nbsp;</DIV>
<DIV>i am using postgresql 7.3.x. I am converting a database in MS SQL server to PostgreSQL. </DIV>
<DIV>&nbsp;</DIV>
<DIV>The main problems i am facing is that in sql server the text comparisons are case insensitive. how can i compare&nbsp;text case insensitive in postgresql without using an upper() or lower() function in both sides (=). Is there any option to set in postgresql?</DIV>
<DIV>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</DIV>
<DIV>&nbsp;</DIV>
<DIV>Another problem is in creating function...</DIV>
<DIV>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().</DIV>
<DIV>&nbsp;</DIV>
<DIV>jinujose</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail">The New Yahoo! Shopping</a> - with improved product search
--0-1735026683-1064460950=:34670--