Re: dynmic column names inside trigger? - Mailing list pgsql-sql

From Tom Lane
Subject Re: dynmic column names inside trigger?
Date
Msg-id 6086.1195577762@sss.pgh.pa.us
Whole thread Raw
In response to dynmic column names inside trigger?  (Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>)
Responses Re: dynmic column names inside trigger?  (Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: dynmic column names inside trigger?
Next
From: "Phillip Smith"
Date:
Subject: Re: [ODBC] string function