summaryrefslogtreecommitdiff
path: root/doc/FAQ
diff options
context:
space:
mode:
Diffstat (limited to 'doc/FAQ')
-rw-r--r--doc/FAQ10
1 files changed, 9 insertions, 1 deletions
diff --git a/doc/FAQ b/doc/FAQ
index 0adb4c7a80f..78f8312a135 100644
--- a/doc/FAQ
+++ b/doc/FAQ
@@ -1,7 +1,7 @@
Frequently Asked Questions (FAQ) for PostgreSQL
- Last updated: Mon Mar 18 14:34:57 EST 2002
+ Last updated: Mon Apr 8 23:22:06 EDT 2002
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -91,6 +91,7 @@
4.22) Why are my subqueries using IN so slow?
4.23) How do I perform an outer join?
4.24) How do I perform queries using multiple databases?
+ 4.25) How do I return multiple rows or columns from a function?
Extending PostgreSQL
@@ -1017,6 +1018,13 @@ SELECT *
databases and merge the information that way.
_________________________________________________________________
+ 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.
+
Extending PostgreSQL
5.1) I wrote a user-defined function. When I run it in psql, why does it