On 6/8/08, Gregory Stark <[EMAIL PROTECTED]> wrote: > I don't think "as late as possible" applies with money. If you were dealing > with approximate measurements you want to round as late as possible because > rounding is throwing away precision. But if you're dealing with money you're > dealing with exact quantities. > > There is only going to be one correct time to round and that's whenever you're > creating an actual ledger item or order line item or whatever. Once you've > calculated how much interest to credit or whatever you have to make that > credit an exact number of cents and the $0.004 you lost or gained in rounding > never comes up again.
Completely correct. In a proper accounting system you can only pull from a very limited subset of arithmetic operations. 'rounding' is not one of them except in the special case you mention above. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers