Skip site navigation (1) Skip section navigation (2)

Re: JOIN results of refcursor functions

From: Milan Oparnica <milan(dot)opa(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: JOIN results of refcursor functions
Date: 2008-11-30 23:13:44
Message-ID: ggv6ir$ma5$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-sql
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 ?

In response to

Responses

pgsql-sql by date

Next:From: Alvaro HerreraDate: 2008-12-01 02:08:46
Subject: Re: JOIN results of refcursor functions
Previous:From: Helio Campos Mello de AndradeDate: 2008-11-28 22:27:50
Subject: Re: Converting between UUID and VARCHAR

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group