"Mark Kirkwood" <[EMAIL PROTECTED]> writes: > IFAIK (dimly recalling numerical analysis courses at university) SUM and ROUND > can *never* be commuted. In general the recommended approach is to round as > late as possible and as few times are possible - so your 1st query is the > correct or best way to go.
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. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers