Can we overload = operator to word numeric = text

From: venkatrao(dot)b(at)tcs(dot)com
To: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Can we overload = operator to word numeric = text
Date: 2010-03-09 10:18:00
Message-ID: OFCAC4BD6F.4669EFA6-ON652576E1.00383B63-652576E1.00389480@tcs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hello,

We have migrated oracle database to postgre.
In oracle char to numeric type conversion is explicit (i.e. we can compare
char = numeric); but in postgre it is throwing errors. There are so many
functions - around 2000, and we can not go and do explict type casting in
every function , where there is problem.

Is there any way to come out of this problem. I mean is there any way to
make = operator work for numeric = charater varying .
Your suggestions are highly appreciated.

Venkat
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jignesh Shah 2010-03-09 10:28:49 has_schema_privilege function
Previous Message Rodger Donaldson 2010-03-09 09:01:52 Re: kernel version impact on PostgreSQL performance

Browse pgsql-novice by date

  From Date Subject
Next Message Jignesh Shah 2010-03-09 10:28:49 has_schema_privilege function
Previous Message Jasen Betts 2010-03-09 10:15:16 Re: Entering a character code in a query