Re: SETOF and language 'plpgsql'

From: "Eric Ridge" <ebr(at)tcdi(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: SETOF and language 'plpgsql'
Date: 2001-11-03 23:51:21
Message-ID: D3ADE25911614840BC69C72E3171E4ED0FBDDD@tcdiexch.tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2001-11-04 00:25:44 Re: Off-Topic: Accounting question
Previous Message Tom Lane 2001-11-03 22:44:07 Re: CREATE TYPE delimiter?