I'm porting a oracle function to postgresql, which has signature like this:
FUNCTION foo
( seq IN varchar
, somerow OUT SomeTable
, otherinfo OUT varchar
)
It's easy to port this function itself to postgresql, but i have problem to execute this function and assign the results into variables:
SELECT (foo(seq)).* INTO (v_somerow, v_otherinfo);
It complains v_somerow can not be row type.
How to handle the result of function foo?
Best regards.
YiHuang.