Received: from lupus.agria.hu (redax@agria.hu [194.196.126.2]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA00623 for ; Thu, 10 Sep 1998 10:02:51 -0400 (EDT) Received: (from redax@localhost) by lupus.agria.hu (8.8.5/8.7.3) id PAA00138; Thu, 10 Sep 1998 15:54:52 +0200 Message-ID: <19980910155452.26701@lupus> Date: Thu, 10 Sep 1998 15:54:52 +0200 From: Zsolt Varga To: pgsql-sql@postgresql.org Subject: TimeStamp for insert/update Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.88 hi! I don't know is it possible or not, to make a filed in any table which contains the insertion/update time I know CREATE TABLE ( instime timestamp default now(),.... ); works well for inserts.. but can I do the same for update? thanks redax ps; or it's a 'rules' question? -- .----------------------------------------------------------. |Zsolt Varga | tel/fax: +36 36 422811 | | AgriaComputer LTD | email: redax@agria.hu | | System Administrator | URL: http://www.agria.hu/ | `----------------------------------------------------------'