Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> writes:
> On 3/31/17 19:03, Yasuo Ohgaki wrote:
>> However, money type does not detect over/underflow and results in
>> strange results.
> This has been fixed in PostgreSQL 10. Please test.
I think the only thing that's actually gotten done is fixing cash_in
to reject out-of-range input values. Somebody ought to fix all the
money arithmetic functions to notice overflow, too; though I'm not
very clear what would be a good strategy in places like cash_mul_flt8,
where you couldn't count on an exact result.
regards, tom lane