Re: [GENERAL] Dynamic access to record columns (in PL/pgsql)

2006-10-02 Thread Erik Jones
Tom Lane wrote: Daniele Mazzini <[EMAIL PROTECTED]> 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

Re: [GENERAL] Dynamic access to record columns (in PL/pgsql)

2006-09-30 Thread Tom Lane
Daniele Mazzini <[EMAIL PROTECTED]> 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 n

[GENERAL] Dynamic access to record columns (in PL/pgsql)

2006-09-30 Thread Daniele Mazzini
Hello 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.