Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I need a clarification. In the non-assignment case, does:
> WHERE numericcol = numericcol * 3.14159
> evaluate "numericcol * 3.14159" as a numeric?
Yup (given my proposed changes that is).
> And does:
> WHERE 5.55 = numericcol * 3.14159
> evaluate "numericcol * 3.14159" as a numeric too?
Yup. The context does not matter: when we have foo * bar, we are going
to decide which kind of * operator is meant without regard to
surrounding context. It's very much a bottom-up process, and has to be.
regards, tom lane