Re: Chart of Accounts

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: justin <justin(at)emproshunts(dot)com>
Cc: hitz(at)jamhitz(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Chart of Accounts
Date: 2008-10-13 10:33:50
Message-ID: 87wsgcrdgx.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

justin <justin(at)emproshunts(dot)com> writes:

> special note do not use only 2 decimal points in the accounting tables. If
> your application uses 10 decimal places somewhere then every table in the
> database that has decimals needs to have the same precision. Nothing is more
> annoying where a transaction says 1.01 and the other side says 1.02 due to
> rounding.

FWIW I think this is wrong. You need to use precisely the number of decimal
places that each datum needs. If you use extra it's just as wrong as if you
use too few.

For example, when you buy gas/petrol at $1.999/gallon and buy 4 gallons you
get charged $8.00 not $7.996. If you fail to round at that point you'll find
that your totals don't agree with the amount of money in your actual bank
account.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2008-10-13 10:35:20 Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
Previous Message Gregory Stark 2008-10-13 10:30:03 Re: PQexecParams question