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
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 ?
In response to
pgsql-sql by date
|Next:||From: Alvaro Herrera||Date: 2008-12-01 02:08:46|
|Subject: Re: JOIN results of refcursor functions|
|Previous:||From: Helio Campos Mello de Andrade||Date: 2008-11-28 22:27:50|
|Subject: Re: Converting between UUID and VARCHAR|