"Jim C. Nasby" <decibel@decibel.org> writes:
> Why are we allowing implicit casts from numeric to floating point?
Because the SQL spec requires it.
2) If the data type of either operand of a dyadic arithmetic op-
erator is approximate numeric, then the data type of the re-
sult is approximate numeric.
It doesn't say to throw an error for mixed-type arithmetic.
Now it also says
1) If the data type of both operands of a dyadic arithmetic opera-
tor is exact numeric, then the data type of the result is exact
numeric, ...
which you could take as requiring us to provide numeric equivalents of
every floating-point operator, but I don't find that argument very
convincing for operations that are inherently not going to give exact
results. The spec demands exact results from addition, subtraction,
and multiplication, but as soon as you get to division they punt; let
alone transcendental functions.
But having said that, I don't have a problem with putting in a
pg_operator entry for numeric_power. And if someone wants to improve
the scale factor calculations therein, go for it. But so far there's
been an extremely low signal-to-noise ratio in this thread ...
regards, tom lane