Hi all,
I've run into an interesting issue when trying to do numeric math. I expected the following to return the same number of decimal digits in the fractional part:
select scale(1/0.6::numeric), scale(1/6::numeric);
But it returns a scale of 16 and 20, respectively.
Any idea why?
--
Nuno Sousa