Received: from biology.nmsu.edu (biology.NMSU.Edu [128.123.5.72]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA36068 for ; Fri, 22 Oct 1999 11:36:13 -0400 (EDT) (envelope-from brook@biology.nmsu.edu) Received: (from brook@localhost) by biology.nmsu.edu (8.8.8/8.8.8) id JAA04682; Fri, 22 Oct 1999 09:36:00 -0600 (MDT) Date: Fri, 22 Oct 1999 09:36:00 -0600 (MDT) Message-Id: <199910221536.JAA04682@biology.nmsu.edu> X-Authentication-Warning: biology.nmsu.edu: brook set sender to brook@biology.nmsu.edu using -f From: Brook Milligan To: grant@intekom.com CC: pgsql-sql@postgreSQL.org In-reply-to: <221099295.28982@212.53.64.128> (grant@intekom.com) Subject: Re: [SQL] Adding a rule to update a last_changed field References: <221099295.28982@212.53.64.128> I'm trying to use a rule to maintain a last_changed field. CREATE RULE rule1 AS ON UPDATE TO thetable DO UPDATE thetable SET last_changed = now() WHERE id = new.id; Try instead something like CREATE RULE rule1 AS ON UPDATE TO thetable DO INSTEAD UPDATE thetable SET last_changed = now(), field1 = new.field1, field2 = new.field2, ... fieldn = new.fieldn WHERE id = new.id; That is, use an INSTEAD rule and replace each field explicitly. Cheers, Brook