Received: from oly.silverlink.net (root@oly.silverlink.net [209.20.168.1]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA71204 for ; Wed, 10 Mar 1999 16:52:43 -0500 (EST) (envelope-from shanen@silverlink.net) Received: from silver170-92.silverlink.net (silver170-92.silverlink.net [209.20.170.92]) by oly.silverlink.net (8.8.5/8.6.9) with SMTP id NAA00424 for ; Wed, 10 Mar 1999 13:59:11 -0800 (PST) Received: by silver170-92.silverlink.net with Microsoft Mail id <01BE6AFC.FD75A100@silver170-92.silverlink.net>; Wed, 10 Mar 1999 13:50:42 -0800 Message-ID: <01BE6AFC.FD75A100@silver170-92.silverlink.net> From: Sue Hanen To: "'pgsql-sql@postgresql.org'" Subject: Recording Date,Time and UserId when a record is modified Date: Wed, 10 Mar 1999 13:49:11 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id QAA71206 Hi When a record has been modified, I would like a field on that record updated with the date and time. Do I use TIMESTAMP? How do I set this up? Is is possible to update this same record with the user ID of the person who modified it? How can I do this? Thanks much Sue