Thread: Passing a row (NEW) as function argument
Hello all. First, thanks for all your help in my (silly) last questions. Now I have a dude about functions that I can't solve with documentation. How can I pass a row of a view as an argument to function. I have tried something like: create function pepis(view_name) returns integer as .../... but I think it doesn't work, because when I call function from insert rule of view, I get an error. I need this for creating views capables of updating and inserting. Thanks again for your ideas. David
DaVinci <bombadil@wanadoo.es> writes: > How can I pass a row of a view as an argument to function. I have tried > something like: > create function pepis(view_name) returns integer as .../... This case turns out to have exposed a number of bugs in both the planner and plpgsql. I think I've fixed 'em all, but you might like to try your example against current sources (CVS, or a snapshot dated after today) to see if it's fixed for you. regards, tom lane