Alvaro Herrera wrote:
> Milan Oparnica escribió:
>> Tom Lane wrote:
>>> Milan Oparnica <milan(dot)opa(at)gmail(dot)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 ?