Re: UPDATE with help of RULES

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Volker Krey <v(dot)krey(at)fz-juelich(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: UPDATE with help of RULES
Date: 2003-11-10 15:00:30
Message-ID: 20031110150030.GB23136@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Nov 10, 2003 at 14:06:22 +0100,
Volker Krey <v(dot)krey(at)fz-juelich(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-11-10 16:27:20 Re: [PERFORM] error while executing a c program with embedded sql
Previous Message radha.manohar 2003-11-10 15:00:27 Re: error while executing a c program with embedded sql