Re: Accounting Schema - Mailing list pgsql-general

From Ludwig Meyerhoff
Subject Re: Accounting Schema
Date
Msg-id Pine.LNX.4.21.0105061003450.6060-100000@ludwig
Whole thread Raw
In response to Re: Accounting Schema  ("Dave Cramer" <Dave@micro-automation.net>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange notices, should I worry?
Next
From: Andrew McMillan
Date:
Subject: Re: Accounting Schema