Re: JOIN results of refcursor functions - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: JOIN results of refcursor functions
Date
Msg-id 20081127204509.GJ4586@alvh.no-ip.org
Whole thread Raw
In response to Re: JOIN results of refcursor functions  (Milan Oparnica <milan.opa@gmail.com>)
Responses Re: JOIN results of refcursor functions
List pgsql-sql
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.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-sql by date:

Previous
From: Milan Oparnica
Date:
Subject: Re: JOIN results of refcursor functions
Next
From: "John Dizaro"
Date:
Subject: Re: UPDATE and DELEte with a lot of register is to slow...