Re: Passing refcursors between pl/pgsql functions

Hi, Merlin.  You wrote:

> In other words, something like this:
>
> create or replace function test() returns setof foo as
> $$
> declare
>    r refcursor;
>    f foo;
>    i int;
> begin
>    open r for select * from foo;
>
>    for i in 1..10
>    loop
>      fetch 1 from r into f;
>      exit when not found;
>      return next f;
>    end loop;
> end;
> $$ language plpgsql;
>
> Having defined refcursor separately from the place it is being used
> really had no bearing on the peculiarities of the 'fetch' statement.
This isn't quite what I was looking for; perhaps I didn't make myself clear.

I want to invoke one function, and get an open refcursor returned.  That
much, I know how to do.

I then want to be able to call a second function, repeatedly, which will
essentially perform a "fetch 20" from that open refcursor.  The second
function should have an input of a refcursor (already open), and should
return a set of rows from the table on which it was opened.

This isn't the way that I would want to do things, but my client's
application structure seems to require it, at least for now.  So, is
there a way to do this?

Reuven

--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner