Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Daniele Mazzini <daniele.mazzini@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux