Re: [SQL] new and old as parameter in a function

2004-05-06 Thread Tom Lane
"Riccardo G. Facchini" <[EMAIL PROTECTED]> writes: > By Reading the documentation, I understand that I can write a PLPGSQL > function that receives a parameter of type RECORD, You misread it --- that's not presently supported. regression=# create function foo(record) returns int as ' regression'#

[SQL] new and old as parameter in a function

2004-05-06 Thread Riccardo G. Facchini
Hi. I'm having some trouble, and I would like to receive some input by the pg community... I would like to write a failry complex PLPGSQL trigger that calls a secondary function. The trigger calls the function with the NEW record that returns a variable of type RECORD whith the NEW variable modif