Received: from localhost (unknown [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id AD9382E0036
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 20 Nov 2007 12:57:29 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 41495-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 20 Nov 2007 12:57:12 -0400 (AST)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id A9E1A2E0045
	for <pgsql-sql@postgresql.org>; Tue, 20 Nov 2007 12:57:18 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lAKGu3t5006087;
	Tue, 20 Nov 2007 11:56:03 -0500 (EST)
To: Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
cc: pgsql-sql@postgresql.org
Subject: Re: dynmic column names inside trigger? 
In-reply-to: <20071120161258.GA27106@apartia.fr> 
References: <20071120161258.GA27106@apartia.fr>
Comments: In-reply-to Louis-David Mitterrand
	<vindex+lists-pgsql-sql@apartia.org>
	message dated "Tue, 20 Nov 2007 17:12:58 +0100"
Date: Tue, 20 Nov 2007 11:56:02 -0500
Message-ID: <6086.1195577762@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/98
X-Sequence-Number: 29626

Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org> 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.

			regards, tom lane