>>>>> "Dean" == Dean Rasheed <dean.a.rasheed@gmail.com> writes:
Dean> I'm not convinced that it is a good idea to change the default
Dean> rounding mode for numeric.
Dean> For one thing, numeric is commonly used for monetary data, and
Dean> changing the default rounding mode might well break existing
Dean> applications where rounding is important, and which rely on the
Dean> current behaviour.
On the other hand, we've had complaints (on IRC) from people doing
calculations with monetary data who complain that we don't do
round-to-even (which is widely known as "Banker's Rounding") as their
requirements demand.
To quote the last person who brought it up there:
>> We have strict accounting practice to follow -- and our CFO has
>> instructed to use even-rounding (aka bankers rounding)... and to not
>> use our typical rounding behavior we learned in 1st grade. :)
Dean> Adding a version of round() with support for a choice of various
Dean> rounding modes might be a better way to go.
There's still the issue of casting to ::numeric(m,n) to consider, and
whatever internal rounding is being done in division and numeric
functions.
Dean> Also, if the default is being changed, I think that merits wider
Dean> discussion (on a thread with a more appropriate title) to see if
Dean> it is likely to be an issue for anyone.
Absolutely.
--
Andrew (irc:RhodiumToad)