X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id BAAA7D1BB41
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 23 Aug 2003 00:31:26 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 61272-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 23 Aug 2003 00:31:15 -0300 (ADT)
Received: from station1.osa.org (rdu57-84-123.nc.rr.com [66.57.84.123])
	by svr1.postgresql.org (Postfix) with ESMTP id 9EC4AD1B9AC
	for <pgsql-sql@postgresql.org>; Sat, 23 Aug 2003 00:31:14 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by station1.osa.org (Postfix on SuSE Linux 8.2 (i686)) with ESMTP id
	0753CC2E
	for <pgsql-sql@postgresql.org>; Fri, 22 Aug 2003 23:32:48 -0400 (EDT)
From: Stuart <sfbarbee@yahoo.com>
Reply-To: sfbarbee@yahoo.com
To: pgsql-sql@postgresql.org
Subject: Auto-update a field when record is changed
Date: Fri, 22 Aug 2003 23:32:47 -0400
User-Agent: KMail/1.5.3
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200308222332.47526.sfbarbee@yahoo.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/283
X-Sequence-Number: 14899

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