Received: from inn.aball.de (inn.aball.de [194.77.20.26]) by hub.org (8.8.8/8.8.8) with ESMTP id DAA14223 for ; Mon, 21 Sep 1998 03:01:09 -0400 (EDT) (envelope-from boddin@teleport.de) Received: from gate.teleport.de (teleport185x-ip.teleport.de [194.77.40.185]) by inn.aball.de (8.8.8/980415/wpv/CA-4) with SMTP id JAA13078 for ; Mon, 21 Sep 1998 09:01:03 +0200 (MET DST) Received: from teleport.de by gate.teleport.de with smtp (Smail3.1.28.1 #1) id m0zKzkW-0001ryC; Mon, 21 Sep 98 08:47 MESZ Sender: boddin@inn.aball.de Message-ID: <360623CF.DD9A03E1@teleport.de> Date: Mon, 21 Sep 1998 09:00:47 -0100 From: "Detlef Boddin S/N O.21" X-Mailer: Mozilla 4.06 [en] (X11; I; Linux 2.0.35 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Q:Update Rule Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I want to save the user and date in a row when the user changed it. If I use an update rule, how can I prevent a loop ? Bad example: create rule r_changed as on update to requesttable do update requesttable set changed_by = current_user, date_of_last_change = current_date; What is better ? Detlef