| From: | "George A(dot)J" <jinujosein(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Case Insensitive comparison |
| Date: | 2003-09-25 03:39:05 |
| Message-ID: | 20030925033905.35938.qmail@web14915.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hornyak Laszlo | 2003-09-25 06:36:05 | Re: [ADMIN] postgres 6.2 vacuum |
| Previous Message | Bruce Momjian | 2003-09-24 22:08:31 | Re: [ADMIN] postgres 6.2 vacuum |