Re: UPDATE with help of RULES

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: UPDATE with help of RULES
Дата
Msg-id 20031110150030.GB23136@wolff.to
обсуждение исходный текст
Ответ на UPDATE with help of RULES  (Volker Krey <v.krey@fz-juelich.de>)
Список pgsql-novice
On Mon, Nov 10, 2003 at 14:06:22 +0100,
  Volker Krey <v.krey@fz-juelich.de> wrote:
> Hello,
>
> Now I want to create a rule that updates the column last_altered of a
> particular row to the date when the row has been altered, i.e. updated
> last time. Creating a rule wasn't a problem, but whatever I tried ended
> in a loop, because the rule reacts with an update on an update and so on...

I think you want to use a before trigger to do this.

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

Предыдущее
От:
Дата:
Сообщение: Re: error while executing a c program with embedded sql
Следующее
От:
Дата:
Сообщение: [Fwd: Re: Questions, help!!]