Auto-update a field when record is changed - Mailing list pgsql-sql

From Stuart
Subject Auto-update a field when record is changed
Date
Msg-id 200308222332.47526.sfbarbee@yahoo.com
Whole thread Raw
Responses Re: Auto-update a field when record is changed  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
Folks,
I was wandering if there was a feasible way to automatically update a field 
in a table, say 'revision_date' in a record whenever any other field in the 
record is changed.  My attempts to use a trigger caused repeating loops and 
bombed with error.  I would like to be able to update such a field 
automatically anytime a record was updated.  Any help would be appreciated.

Thanks,

Stuart



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Delete denied?
Next
From: Stephan Szabo
Date:
Subject: Re: Auto-update a field when record is changed