Re: Dynamic access to record columns (in PL/pgsql) - Mailing list pgsql-general

From Tom Lane
Subject Re: Dynamic access to record columns (in PL/pgsql)
Date
Msg-id 13577.1159634869@sss.pgh.pa.us
Whole thread Raw
In response to Dynamic access to record columns (in PL/pgsql)  (Daniele Mazzini <daniele.mazzini@libero.it>)
Responses Re: Dynamic access to record columns (in PL/pgsql)  (Erik Jones <erik@myemma.com>)
List pgsql-general
Daniele Mazzini <daniele.mazzini@libero.it> writes:
> I have a trigger procedure which I want to be called after insert or
> update on different tables. In this procedure, I need to find the values
> of key fields for the affected table in the NEW record, but I can't find
> a way to access a field the name of which I only know at execution time.

There is no way to do that in plpgsql.  You could do it in the other PLs
(eg plperl, pltcl) since they are not as strongly typed as plpgsql.

            regards, tom lane

pgsql-general by date:

Previous
From: "Wyatt Tellis"
Date:
Subject: Cause of ERROR: could not open relation 1663/856689/856777: Invalid argument?
Next
From: Gene Wirchenko
Date:
Subject: Re: cyclical redundancy checksum algorithm(s)?