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 323783A5C04 for ; Wed, 26 Jan 2005 16:45:21 +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 41374-08 for ; Wed, 26 Jan 2005 16:45:11 +0000 (GMT) Received: from hm03.locaweb.com.br (hm03.locaweb.com.br [200.234.203.3]) by svr1.postgresql.org (Postfix) with SMTP id 24F633A5BCE for ; Wed, 26 Jan 2005 16:45:09 +0000 (GMT) Received: (qmail 11197 invoked by uid 0); 26 Jan 2005 16:45:03 -0000 Received: from unknown (200.246.179.93) by hm03.locaweb.com.br with QMTP; 26 Jan 2005 16:45:03 -0000 Received: (qmail 2202 invoked from network); 26 Jan 2005 16:45:04 -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; 26 Jan 2005 16:45:05 -0000 Received: from 127.0.0.1 (AVG SMTP 7.0.300 [265.7.4]); Wed, 26 Jan 2005 15:43:28 -0200 Message-ID: <41F7D6BC.6090402@microwork.inf.br> Date: Wed, 26 Jan 2005 14:43:24 -0300 From: Wilton User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: pt-br, pt To: pgsql-sql@postgresql.org Subject: Postgresql number of command 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: 200502/11 X-Sequence-Number: 20122 Hi... People I would like to know if inside of a function that has been called by a trigger, what instruction the SQL called, i do not wanna know if itīs a insert or a update or a delete (tg_op)... i need the full instruction. For example: I wanna know the number of the instruction: update telefone set numero = '9999-2222'; Thanks, and sorry if itīs not here to put the message... just say me where i need to write this question... Thank you very much Wilton Ruffato Wonrath -- 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