Re: How to ensure a log-entry is created based on state of data in other tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to ensure a log-entry is created based on state of data in other tables
Дата
Msg-id CAKFQuwYuYs0nmWpgLUwfTP5pF7zZgxJP+BqFj8gToZ4=RH89SQ@mail.gmail.com
обсуждение исходный текст
Ответ на How to ensure a log-entry is created based on state of data in other tables  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Re: How to ensure a log-entry is created based on state of data in other tables
Список pgsql-sql
Дерево обсуждения
On Thu, Feb 9, 2023 at 12:24 AM Andreas Joseph Krogh <andreas@visena.com> wrote:

Is there a better way, using some extra tables to do bookkeeping can the have constraints ensuring this business-requirement?



Every time an activity newly becomes "Not Done" increment a "not done seen counter" and likewise with a "done seen counter".  Whenever the former is greater than the later you have one or more not done activities.

David J.

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

Предыдущее
От: Steve Midgley
Дата:
Сообщение: Re: How to ensure a log-entry is created based on state of data in other tables
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: How to ensure a log-entry is created based on state of data in other tables