Can we overload = operator to word numeric = text
| От | venkatrao.b@tcs.com |
|---|---|
| Тема | Can we overload = operator to word numeric = text |
| Дата | |
| Msg-id | OFCAC4BD6F.4669EFA6-ON652576E1.00383B63-652576E1.00389480@tcs.com обсуждение исходный текст |
| Ответы |
Re: Can we overload = operator to word numeric = text
|
| Список | 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 по дате отправления: