Re: UPDATE with help of RULES - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: UPDATE with help of RULES
Date
Msg-id 20031110150030.GB23136@wolff.to
Whole thread Raw
In response to UPDATE with help of RULES  (Volker Krey <v.krey@fz-juelich.de>)
List 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 by date:

Previous
From:
Date:
Subject: Re: error while executing a c program with embedded sql
Next
From:
Date:
Subject: [Fwd: Re: Questions, help!!]