Re: JOIN results of refcursor functions

Alvaro Herrera wrote:
> Milan Oparnica escribió:
>> Tom Lane wrote:
>>> Milan Oparnica <milan.opa@gmail.com> writes:
>>>> Is there any way to use INNER, LEFT and RIGHT JOIN between functions  
>>>> returning refcursor type.
>>> No.  Make them return setof whatever instead.
>>>
>> I would like yo avoid creating custom composite types required for setof.
> 
> Then use OUT variables.
> 

I've searched documentation (8.3) and didn't find a way to use OUT 
variables in same manner as SETOF (RETURN NEXT doesn't create a record 
type result).

Can you please give an example of how to return select fld1, fld2 from 
table through OUT variables so the caller gets records ? If possible, 
use refcursor as a source ?