Case Insensitive comparison

From: "George A(dot)J" <jinujosein(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Case Insensitive comparison
Date: 2003-09-25 03:35:50
Message-ID: 20030925033550.35699.qmail@web14915.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kumar 2003-09-25 04:11:28 Large Objects and Bytea
Previous Message Richard Huxton 2003-09-24 19:36:31 Re: Especial delimiters caracter