Received: from kss.net.au ([203.41.122.41]) by hub.org (8.10.1/8.10.1) with ESMTP id e934Kar98773 for ; Tue, 3 Oct 2000 00:20:36 -0400 (EDT) Received: from kss.net.au (coco [10.10.1.9]) by kss.net.au (8.8.7/8.8.7) with ESMTP id PAA28423 for ; Tue, 3 Oct 2000 15:19:58 +1000 Message-ID: <39D96C98.9C7A6A55@kss.net.au> Date: Tue, 03 Oct 2000 15:20:24 +1000 From: Carolyn Lu Wong Organization: Kwiker Software Solutions X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: trigger examples Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/10 I need to write a trigger to create a new record in log table if it's a new record or if column A and B changes. Can someone give me an example how to do this. Are there any sites that gives trigger examples?? Thanks.