Re: [HACKERS] [SQL] Inconsistent or incomplete behavior obverse in where

2002-11-15 Thread Paul Ogden
Josh, Thanks for the reply. Much of what you say is as we expected. I see that 7.3 has addressed the "Unable to identify an operator '=' for types 'numeric' and 'double precision'" problem, but I'm not sure how. Context-sensitive approach? Overloaded operator approach? Something else ( is the

Re: [HACKERS] [SQL] Inconsistent or incomplete behavior obverse in where

2002-11-12 Thread Tom Lane
"Josh Berkus" <[EMAIL PROTECTED]> writes: > Now, that's interesting. Why would defining a "numeric = float" have > broken "numeric = integer"? There's no reason I can think of. The problem probably is that the parser now finds two possible interpretations that look equally good to it, so it ca

Re: [HACKERS] [SQL] Inconsistent or incomplete behavior obverse in where

2002-11-12 Thread Josh Berkus
Paul, > "Unable to identify an operator '=' for types 'numeric' and 'double > precision' You will have to retype this query using an explicit cast" This is due, as you surmised, to decimal values defaulting to floats. While there is little problem with an = operator for numeric and float, you wo