[GENERAL] How to handle nested record data.

[yi huang]

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.