Hi,
I need to call a function when updating on a view, like :
create rule udps_upd as on update to udps do
instead select function_call();
My problem: how do I get a reference to OLD and NEW ?
I tried function_call(OLD, NEW) -- parse error
function_call(OLD.oid, NEW.oid) -- no such attributes
and function_call(OLD.ctid, NEW.ctid).
The last executes, but unfortunately I have no idea how to
proceed in the called function. In all fmgr macros, not one
seems to be concerned with a beast like a tid.
Or is there some information available in the passed
FunctionCallInfoData.context ?
Cheers,
Han Holl