Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D74482E36EA for ; Thu, 29 Nov 2007 09:02:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 32227-09-2 for ; Thu, 29 Nov 2007 09:02:02 -0400 (AST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 0BDC62E360C for ; Thu, 29 Nov 2007 09:02:00 -0400 (AST) Received: (qmail 7586 invoked by uid 0); 29 Nov 2007 13:01:59 -0000 Received: from 195.141.84.215 by www080.gmx.net with HTTP; Thu, 29 Nov 2007 14:01:59 +0100 (CET) Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="us-ascii" Date: Thu, 29 Nov 2007 14:01:59 +0100 From: "Christian Kindler" Message-ID: <20071129130159.110470@gmx.net> MIME-Version: 1.0 Subject: statement-level trigger sample out there? To: pgsql-sql@postgresql.org X-Authenticated: #27759442 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1+ru0NpEparW15cJFvcXCid7bHqxgPO0cYZ/grWvj Mc5RqI4u2SNRPeDirhcPm47gQjppG6gx6CnQ== X-GMX-UID: dI98dhMDIydmNXf202Zr3VpSa2FkZtX0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.007 tagged_above=0 required=5 tests=AWL=1.006, BAYES_50=0.001 X-Spam-Level: * X-Archive-Number: 200711/152 X-Sequence-Number: 29680 Hi Can anyone provide me a simple example of a statement-level trigger? Problem is I do not know how to access the old.*, new.* values. Thanks Chris -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail