Re: Returning a CURSOR from plpgsql functions - Mailing list pgsql-general

On Thu, 31 Jan 2002, Darren Ferguson wrote:

> I believe that you can return CURSORS from plpgsql functions however i
> have not been able to figure out exactly how.
>
> Anybody have any ideas ???

create table aa(a int, b int, c int);
create function f() returns refcursor as '
declare
 r refcursor;
begin
 open r for select * from aa;
 return r;
end;' language 'plpgsql';