X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8852C3A5E34 for ; Thu, 27 Jan 2005 11:22:53 +0000 (GMT) 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 43503-10 for ; Thu, 27 Jan 2005 11:22:48 +0000 (GMT) Received: from hm03.locaweb.com.br (hm03.locaweb.com.br [200.234.203.3]) by svr1.postgresql.org (Postfix) with SMTP id 68AE63A5E1B for ; Thu, 27 Jan 2005 11:22:49 +0000 (GMT) Received: (qmail 63365 invoked by uid 0); 27 Jan 2005 11:22:47 -0000 Received: from unknown (200.246.179.93) by hm03.locaweb.com.br with QMTP; 27 Jan 2005 11:22:47 -0000 Received: (qmail 27821 invoked from network); 27 Jan 2005 11:22:48 -0000 Received: from unknown (HELO ?192.168.1.86?) (wilton.wonrath@microwork.inf.br@200.246.46.224) by hm28.locaweb.com.br with SMTP; 27 Jan 2005 11:22:48 -0000 Received: from 127.0.0.1 (AVG SMTP 7.0.300 [265.7.4]); Thu, 27 Jan 2005 09:21:20 -0300 Message-ID: <41F8DCBB.3040707@microwork.inf.br> Date: Thu, 27 Jan 2005 09:21:15 -0300 From: Wilton User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: pt-br, pt To: pgsql-sql@postgresql.org Subject: Complete instruction in a trigger Mime-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/279 X-Sequence-Number: 20067 Hi... People, i wanna know how can i know inside of a function whar the trigger called, i mean which instruction SQL it called. I do not wanna know if itīs a insert, update or delete (tp_op), i need to know the complete instruction. For example, i need to know something like this: update phones set number = '9999-2222'; Do you know if maybe exists a tg_stantement? Thanks very much... see ya -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.4 - Release Date: 25/1/2005