Received: from kss.net.au ([203.41.122.41]) by hub.org (8.10.1/8.10.1) with ESMTP id e9365Zr26313 for ; Tue, 3 Oct 2000 02:05: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 RAA32078 for ; Tue, 3 Oct 2000 17:04:58 +1000 Message-ID: <39D98534.31BC8197@kss.net.au> Date: Tue, 03 Oct 2000 17:05: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: Re: trigger examples References: <39D96C98.9C7A6A55@kss.net.au> <39D9636B.5B45952C@smartt.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/14 drfrog@smartt.com wrote: > > Carolyn Lu Wong wrote: > > > > 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. > > the fulltextindex in the contrib dir gives an example The example uses C. Is it possible to create the trigger with plpsql function?