Daniele Mazzini <daniele(dot)mazzini(at)libero(dot)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
In response to
pgsql-general by date
|Next:||From: Jan Danielsson||Date: 2006-09-30 18:34:05|
|Subject: Potentially annoying question about date ranges|
|Previous:||From: Tom Lane||Date: 2006-09-30 16:28:17|
|Subject: Re: memory issues when running with mod_perl |