Passing RECORD variable from func1() to func2()
От | Henry Combrinck |
---|---|
Тема | Passing RECORD variable from func1() to func2() |
Дата | |
Msg-id | 51220.165.165.166.163.1094494021.squirrel@airmail.metroweb.co.za обсуждение исходный текст |
Ответы |
Re: Passing RECORD variable from func1() to func2()
Re: Passing RECORD variable from func1() to func2() |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: