Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8C1112E009B for ; Thu, 22 Nov 2007 09:55:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30364-01-5 for ; Thu, 22 Nov 2007 09:55:29 -0400 (AST) Received: from sargon.lncsa.com (sargon.lncsa.com [212.99.8.251]) by postgresql.org (Postfix) with ESMTP id DEB5A2E00BC for ; Thu, 22 Nov 2007 09:55:01 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by sargon.lncsa.com (Postfix) with ESMTP id 880253015E2C for ; Thu, 22 Nov 2007 14:55:00 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at lncsa.com Received: from sargon.lncsa.com ([127.0.0.1]) by localhost (sargon.lncsa.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id cZVI7dwk0uCP for ; Thu, 22 Nov 2007 14:55:00 +0100 (CET) Received: from zenon.apartia.fr (zenon.apartia.fr [10.0.3.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "zenon.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by sargon.lncsa.com (Postfix) with ESMTP id 6979D3013BA0 for ; Thu, 22 Nov 2007 14:55:00 +0100 (CET) Received: from trajan.apartia.fr (trajan.apartia.fr [10.0.3.121]) by zenon.apartia.fr (Postfix) with ESMTP id DEBD459C5000C for ; Thu, 22 Nov 2007 14:54:59 +0100 (CET) Received: by trajan.apartia.fr (Postfix, from userid 1000) id CFA73256ED73; Thu, 22 Nov 2007 14:54:59 +0100 (CET) Date: Thu, 22 Nov 2007 14:54:59 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: Re: dynmic column names inside trigger? Message-ID: <20071122135459.GB10426@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org References: <20071120161258.GA27106@apartia.fr> <6086.1195577762@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6086.1195577762@sss.pgh.pa.us> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/117 X-Sequence-Number: 29645 On Tue, Nov 20, 2007 at 11:56:02AM -0500, Tom Lane wrote: > Louis-David Mitterrand writes: > > I'd like to use it on other tables an columns but how can the column > > name be dynamic inside the procedure. > > It can't --- plpgsql has no support for that. You could probably make > it work in some of the other PL languages, such as plperl or pltcl, > which are less strongly typed. Hi Tom, What the performance penality of using plperl vs. plpgsql ? Thanks,