Received: from gnumed.dhs.org (modem59.malleenet.net.au [203.143.67.123] (may be forged)) by postgresql.org (8.11.3/8.11.4) with SMTP id f7EEXtP32143 for ; Tue, 14 Aug 2001 10:33:56 -0400 (EDT) (envelope-from hherb@malleenet.net.au) Received: (qmail 9162 invoked by uid 8); 14 Aug 2001 14:33:48 -0000 Received: from pc-00071.e-smith.gnumed.dhs.org (192.168.1.71, claiming to be "munin.gnumed.dhs.org") by bifrost.e-smith.gnumed.dhs.org with SMTP id smtpdMOUjCG; Wed, 15 Aug 2001 00:33:39 EST Content-Type: text/plain; charset="iso-8859-1" From: Horst Herb To: pgsql-sql@postgresql.org Subject: how to use record type Date: Wed, 15 Aug 2001 00:34:33 +1000 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01081500343310.01835@munin.gnumed.dhs.org> Content-Transfer-Encoding: 8bit X-Archive-Number: 200108/190 X-Sequence-Number: 4415 Help please! How do I actually insert the variables OLD or NEW or a record type into a table from within a trigger? Like doing the following: drop table th1; create table th1( id serial, text text ); drop table th_audit; create table th1_audit( ts timestamp default now() ) inherits(th1); drop function thaudit(); create function thaudit() returns opaque as ' begin -- I want to insert OLD into th_audit - how do I do this??? return NEW; end; ' language 'plpgsql'; drop trigger ta on th1; create trigger ta before delete or update on th1 for each row execute procedure thaudit(); Reagrds, Horst