is it possible to return multiple rows in a PL/PGSQL function?

From: "Eric Peters" <eric(at)peters(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: is it possible to return multiple rows in a PL/PGSQL function?
Date: 2002-02-18 21:34:31
Message-ID: 014a01c1b8c4$0f91f8d0$4500a8c0@er1c
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to return multiple rows in a PL/PGSQL function?

I saw an old thread from 2000 that said no, but some "references" to 7.1/7.2's possible ability to.
(http://postgresql.linux.cz/mhonarc/pgsql-sql/2000-08/msg00237.html)

Basically can you do a setof in a pl/pgsql function (or even pl/perl?) or am I just dreaming? :)

Thanks,

Eric

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sharon Cowling 2002-02-18 21:39:00 Can't get to interactive documentation
Previous Message Tom Lane 2002-02-18 21:15:20 Re: Updates thru view