Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id 20DAA47605E for ; Tue, 9 Apr 2002 00:18:17 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g394IDf18569; Tue, 9 Apr 2002 00:18:13 -0400 (EDT) From: Bruce Momjian Message-Id: <200204090418.g394IDf18569@candle.pha.pa.us> Subject: Re: [GENERAL] PL/pgsql return resultset/cursor? In-Reply-To: To: Peter Eisentraut Date: Tue, 9 Apr 2002 00:18:13 -0400 (EDT) Cc: Richard Emberson , PostgreSQL-documentation X-Mailer: ELM [version 2.4ME+ PL97 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200204/9 X-Sequence-Number: 1334 Peter Eisentraut wrote: > Bruce Momjian writes: > > > I have added an FAQ item and improved the documentation. Seems the > > official current docs aren't being built regularly, (last April 3), > > Probably because the markup is temporarily broken. Oh, is that why. I just fixed it. > > so I pointed to my web copy in the FAQ: > > > > 4.25) How do I return multiple rows or columns from a function? > > > > You can return result sets from PL/pgSQL functions using refcursors. See > > http://candle.pha.pa.us/main/writings/pgsql/sgml/plpgsql-cursors.html, > > section 23.7.3.3. > > Please do not publish links to the development docs. How do I get around that? I would have to duplicate the doc information in the FAQ; seems ugly. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026