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$ (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group