From ccfa6f1c1e66afbd331ea7bc12c29245bae0c499 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 17 Mar 2003 19:53:08 +0000 Subject: [PATCH] Add mention of new sets returning functions capability. --- doc/FAQ | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) diff --git a/doc/FAQ b/doc/FAQ index 4ec1494687..8a1af3b772 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Mon Mar 17 14:47:21 EST 2003 + Last updated: Mon Mar 17 14:52:36 EST 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -1060,10 +1060,8 @@ CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP ); 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://www.PostgreSQL.org/docs/view.php?version=current&idoc=1&file=pl - pgsql-cursors.html, section 23.7.3.3. + In 7.3, you can easily return multiple rows or columns from a + function, http://techdocs.postgresql.org/guides/SetReturningFunctions. 4.26) Why can't I reliably create/drop temporary tables in PL/PgSQL functions? -- 2.40.0