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
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 |
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 |