Re: SETOF and language 'plpgsql' - Mailing list pgsql-general

From Eric Ridge
Subject Re: SETOF and language 'plpgsql'
Date
Msg-id D3ADE25911614840BC69C72E3171E4ED0FBDDD@tcdiexch.tcdi.com
Whole thread Raw
In response to SETOF and language 'plpgsql'  ("Eric Ridge" <ebr@tcdi.com>)
List pgsql-general
> I think you misread that ;-).  What I was saying was that there wasn't
> (any longer) anything outside plpgsql that would prevent it from
> returning sets.  There would be a nontrivial amount of work to do
inside
> plpgsql to make it happen; see Jan's followup

Thanks for the clarification.  :)

> > It's over a year later.  What's the status today?
>
> About the same.
>
> There is support in 7.2 for plpgsql functions to return references to
> cursors. This is not by any means the same thing as a SETOF result,
> but it can serve some of the same purposes.

I'll look into this to see if it can do what I want.  Or if I can do
what it wants!

eric

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE TYPE delimiter?
Next
From: Mike Mascari
Date:
Subject: Re: Off-Topic: Accounting question