Returning multiple rows from plpgsql function

Hi Everybody,

How can I return multiple rows from a plpqsql function. I wanted to write a function which gives me the result of the final select query from a bunch of nested select queries. What return type should use? The return type %ROWTYPE only returns a single row. In SQL function I can do this by stating that the function returns a setof record but it doesnt work in plpgsql function.

Thanks,

Tarun

---------------------------------
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day