Re: Money type todos?

Andrew Dunstan wrote:
> August Zajonc wrote:
>>  The only other nice thing would be user defined precision, but
>> can live without that as most currencies work under nnn.mm. 
> 
> That's useless for our system at least. The minimum scale we use for
> money values is 5. I guess we can just continue to use numeric though.
> 

Emailing off list with Andrew I'm reminded of one other feature that
would be potentially valuable in a money type, and that's being able to
specify the method of rounding.

There end up being a number of different rounding methods out there, and
in some cases it is very valuable to critical to follow a certain
method, usually dictated by externalities such as trading partners etc.

This could probably be a compile time flag even for postgresql and is
obviously a low priority behind speed.

Symmetric Arithmetic Rounding
Bankers Rounding
Round-half-down

Not sure its worth doing and if so probably a low priority, just
mentioning it for completeness.

- August