Re: Accounting Schema

Поиск
Список
Период
Сортировка
От Ludwig Meyerhoff
Тема Re: Accounting Schema
Дата
Msg-id Pine.LNX.4.21.0105061003450.6060-100000@ludwig
обсуждение исходный текст
Ответ на Re: Accounting Schema  ("Dave Cramer" <Dave@micro-automation.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strange notices, should I worry?
Следующее
От: Andrew McMillan
Дата:
Сообщение: Re: Accounting Schema