Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 689442E004A for ; Tue, 8 Apr 2008 10:22:11 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88460-05 for ; Tue, 8 Apr 2008 10:22:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by developer.postgresql.org (Postfix) with ESMTP id D4E832E0031 for ; Tue, 8 Apr 2008 10:22:05 -0300 (ADT) Received: from perhan.alvh.no-ip.org (200-126-91-169.bk6-dsl.surnet.cl [200.126.91.169]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m38DMYx7011728 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 8 Apr 2008 06:22:37 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 63EB547C55; Tue, 8 Apr 2008 09:21:57 -0400 (CLT) Date: Tue, 8 Apr 2008 09:21:57 -0400 From: Alvaro Herrera To: Martin Edlman Cc: pgsql-sql@postgresql.org Subject: Re: pl/PgSQL, variable names in NEW Message-ID: <20080408132157.GF5290@alvh.no-ip.org> References: <47FA034B.7090201@fortech.cz> <162867790804070511y7266c911w370db97a78c3c519@mail.gmail.com> <47FB51C7.6090509@fortech.cz> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <47FB51C7.6090509@fortech.cz> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 08 Apr 2008 06:22:38 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/50 X-Sequence-Number: 30589 Martin Edlman wrote: > I don't want to rewrite whole trigger to plPerl as I would have to use > DBD-PgSPI. Huh? Certainly not -- there are functions in PL/Perl for this. See spi_exec_query in http://www.postgresql.org/docs/8.3/static/plperl-database.html -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.