Re: View vs Constantly Updated Table

Поиск
Список
Период
Сортировка
От marcin mank
Тема Re: View vs Constantly Updated Table
Дата
Msg-id b1b9fac60812161216q7c695bb7kc57d6f16d9b23f21@mail.gmail.com
обсуждение исходный текст
Ответ на View vs Constantly Updated Table  (Ketema Harris <ketema@ketema.net>)
Список pgsql-general
It is generally better to save the balance. The general rule in
accounting systems design is "what can be printed, should be
explicitly on disk". for an invoice:

value before tax, tax percentage, value after tax, total before tax,
total after tax, etc, should all be saved explicitly.

An account should have a balance. Every operation should have balance
before operation, value, balance after operation. You should never
update an operation.

This way when business rules change all previous documents are stored
in consistent state.

Greetings
Marcin Mańk

В списке pgsql-general по дате отправления:

Предыдущее
От: Madison Kelly
Дата:
Сообщение: Re: TIMESTAMP with a timezone offset
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Isolating a record column from a PL-Pgsql function call ?