Re: [GENERAL] Can we overload = operator to word numeric = text

2010-03-09 Thread venkatrao . b
Dear Pavel, Thanks a lot... It worked. Regards, Venkat From: Pavel Stehule To: venkatra...@tcs.com Cc: pgsql-nov...@postgresql.org, pgsql-general@postgresql.org Date: 03/09/2010 04:07 PM Subject: Re: [GENERAL] Can we overload = operator to word numeric = text 2010/3/9 : > >

Re: [GENERAL] Can we overload = operator to word numeric = text

2010-03-09 Thread Pavel Stehule
2010/3/9 : > > 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 i

[GENERAL] Can we overload = operator to word numeric = text

2010-03-09 Thread venkatrao . b
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 , wh