Received: from smartt.com (ktk6.smartt.com [209.52.5.253]) by hub.org (8.10.1/8.10.1) with ESMTP id e934Oer01422 for ; Tue, 3 Oct 2000 00:24:40 -0400 (EDT) Received: from smartt.com (alpnb13234.smarttadsl.com [209.52.13.234]) by smartt.com (8.9.3/8.9.0) with ESMTP id VAA04910; Mon, 2 Oct 2000 21:31:54 -0700 (PDT) Message-ID: <39D9636B.5B45952C@smartt.com> Date: Mon, 02 Oct 2000 21:41:15 -0700 From: drfrog@smartt.com X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i586) X-Accept-Language: en MIME-Version: 1.0 To: Carolyn Lu Wong CC: "pgsql-sql@postgresql.org" Subject: Re: trigger examples References: <39D96C98.9C7A6A55@kss.net.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/11 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