X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 93CB9DA21A for ; Wed, 2 Nov 2005 19:34:16 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75312-06 for ; Wed, 2 Nov 2005 23:34:13 +0000 (GMT) Received: from nz.telogis.com (unknown [203.98.10.169]) by svr1.postgresql.org (Postfix) with ESMTP id E1A4CD9FA3 for ; Wed, 2 Nov 2005 19:34:14 -0400 (AST) Received: from [192.168.3.1] ([192.168.3.1]) by nz.telogis.com with esmtp; Thu, 03 Nov 2005 12:34:16 +1300 id 006D3D4E.43694CF8.00007D64 Message-ID: <43694CF6.4050605@telogis.com> Date: Thu, 03 Nov 2005 12:34:14 +1300 From: Ralph Mason User-Agent: Thunderbird 1.4 (Windows/20050908) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Trigger Rowsets Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/36 X-Sequence-Number: 15293 I want to do statement level triggers for performance, but it seems there is no 'updated', 'inserted', or 'deleted' tables inside the trigger and nothing I can find in the documentation that offers similar functionality. Is there any way that I can access only those rows that were changed? Thanks Ralph