Hello Hopefully someone can shed some light on the following issue. After chatting at irc.freenode.net/#postgresql, without success, this is my last effort before giving up and using a temp table.
Essentially, I would like to pass a RECORD variable from one function to another using plpgsql: func2(record) rec1 alias for $1 begin -- do work on rec1.* raise notice ''val1=% val2=%'', rec1.col1, rec1.col2; end; func1() declare temprec record; begin for temprec in select * from table1, table2... loop ... select func2(temprec); /* pass temprec row to func2() */ ... end loop; end; Then call with: SELECT FUNC1(); Is this possible? The docs only speak about RECORD type being used to *return* rows, but not to pass it. Any pointers would be appreciated. Regards Henry -------------------------------------------------------- This message was sent using MetroWEB's AirMail service. http://www.metroweb.co.za/ - full access for only R73. Free Web Accelerator, WebMail, Calendar, Anti-Virus, Anti-Spam, 10 emails, 100MB personal webspace, and more! Phone Now! 086 11 11 440 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster