Re: is it possible to return multiple rows in a PL/PGSQL

From: Darren Ferguson <darren(at)crystalballinc(dot)com>
To: Eric Peters <eric(at)peters(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: is it possible to return multiple rows in a PL/PGSQL
Date: 2002-02-18 22:00:20
Message-ID: Pine.LNX.4.10.10202181659260.3711-100000@thread.crystalballinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In pl/tcl you can return a tcl list of list as a varchar.

In plpgsql you could return a CURSOR and then you would be able to iterate
through the cursor row by row

Darren Ferguson

On Mon, 18 Feb 2002, Eric Peters wrote:

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-02-18 22:20:10 Re: PgManage update
Previous Message Serkan Bekta? 2002-02-18 21:43:32 Turkish Code Page ?