Re: [GENERAL] Dynamic Assignment

2011-03-23 Thread Pavel Stehule
2011/3/23 Andy Chambers : > Hi All, > > In a trigger function, I'm trying to set the variable "pkey" to be one of > the columns > in the automatic variable "NEW".  Which one depends on some metadata that is > available at > run-time.  I'm having a hard time using an automatic variable in a dynamic

[GENERAL] Dynamic Assignment

2011-03-23 Thread Andy Chambers
Hi All, In a trigger function, I'm trying to set the variable "pkey" to be one of the columns in the automatic variable "NEW". Which one depends on some metadata that is available at run-time. I'm having a hard time using an automatic variable in a dynamic execute command. I get the err