Re: Returning a CURSOR from plpgsql functions

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';