X-Original-To: pgsql-sql@postgresql.org Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by postgresql.org (Postfix) with ESMTP id 433C14763E7 for ; Thu, 13 Mar 2003 10:26:19 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.36 #2) id 18tUb8-0004uI-0Z for pgsql-sql@postgresql.org; Thu, 13 Mar 2003 15:26:23 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 05AB21650F for ; Thu, 13 Mar 2003 15:26:22 +0000 (GMT) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 53A4F164F7 for ; Thu, 13 Mar 2003 15:26:21 +0000 (GMT) Content-Type: text/plain; charset="us-ascii" From: Richard Huxton Organization: Archonet Ltd To: pgsql-sql@postgresql.org Subject: A Brief Real-World Trigger Example Date: Thu, 13 Mar 2003 15:26:20 +0000 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200303131526.20640.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Archive-Number: 200303/335 X-Sequence-Number: 12374 I've put some notes from a real case I've been working on at: http://techdocs.postgresql.org/guides/BriefTriggerExample Any feedback/comments regarding accuracy/style etc gratefully received. --=20 Richard Huxton