Re: Accounting Schema

From: Ludwig Meyerhoff <ludwig(at)antar(dot)com>
To: Dave Cramer <Dave(at)micro-automation(dot)net>
Cc: GH <grasshacker(at)over-yonder(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Accounting Schema
Date: 2001-05-06 08:05:16
Message-ID: Pine.LNX.4.21.0105061003450.6060-100000@ludwig
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hallo!

> Ya, thought of that. I generally prefer to keep my data model consistent. It
> has some merit though, thanks
Keep all amounts positive, cumulate income and outcome, and to calculate
profit/loss subtract the smaller number from the bigger one.
So You will avoid negative numbers (You will only have to put the result
in the proper column: profit/loss)

LUdwig

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew McMillan 2001-05-06 10:17:08 Re: Accounting Schema
Previous Message Ian Harding 2001-05-06 05:28:58 Re: nested if , and how to trigger....