Bruce Momjian <maillist@candle.pha.pa.us> writes:
> Should I add this to the TODO list?
>>
>> What's needed is explicit rounding. Instead of letting the compiler do
>> the rounding during its implicit float-to-int conversion (which
>> generally truncates towards 0 or towards -infinity), do
>> [snip]
>> The other cash functions also need to be looked at for rounding
>> sloppiness, so I see no point in committing this fix by its lonesome.
Yes, that still needs to be dealt with. I suggest
* Fix roundoff problems in "cash" datatype.
Actually, the whole cash datatype ought to be obsoleted by real
fixed-point-numeric support, but that's a *much* bigger project...
regards, tom lane