Passing RECORD variable from func1() to func2()

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