Re: SETOF and language 'plpgsql'

From: "Eric Ridge" <ebr(at)tcdi(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: SETOF and language 'plpgsql'
Date: 2001-11-03 21:08:43
Message-ID: D3ADE25911614840BC69C72E3171E4ED02812D@tcdiexch.tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> How do you return a "setof <datatype>" from a plpgsql function?

I'll respond to my own post...

After searching the archives I found a post by Jan Wieck that basically
says, "You can't....not sure if we will be able to do it for 7.2".
Then Tom Lane replied, "...If you want to fix plpgsql so that it retains
state and can produce multiple elements of a set over repeated calls,
the same way that SQL functions do, then it could be done today."

http://archives2.us.postgresql.org/pgsql-sql/2000-08/msg00244.php
and
http://archives2.us.postgresql.org/pgsql-sql/2000-08/msg00252.php

They are dated August 2000.

It's over a year later. What's the status today? Is this planned for
7.2? The TODO list doesn't mention it.

eric

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-03 21:42:41 Re: SETOF and language 'plpgsql'
Previous Message Tom Lane 2001-11-03 21:05:48 Re: CREATE TYPE delimiter?