Can we overload = operator to word numeric = text - Mailing list pgsql-general

From venkatrao.b@tcs.com
Subject Can we overload = operator to word numeric = text
Date
Msg-id OFCAC4BD6F.4669EFA6-ON652576E1.00383B63-652576E1.00389480@tcs.com
Whole thread Raw
Responses Re: Can we overload = operator to word numeric = text
List pgsql-general

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


pgsql-general by date:

Previous
From: Rodger Donaldson
Date:
Subject: Re: kernel version impact on PostgreSQL performance
Next
From: Jignesh Shah
Date:
Subject: has_schema_privilege function