I have a large function that's doing a number of calcs. The final
return value is wrong for a simple reason: any division statement
where the numerator is less than the denominator is returning a zero.
Each of these statements return a 0, even when properly cast:
select 1/100
select Cast(1 / 100 As decimal)
select Cast(1 / 100 As numeric(6,2))
How can I write statements that returns a decimal?
The problem doesn't appear to be that Postgres won't return decimal
values, as these statements return the correct value:
select .01
select Cast(.01 As decimal)