Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit2aeebfc

Browse files
committed
Update FAQ.
1 parent0325149 commit2aeebfc

File tree

2 files changed

+22
-2
lines changed

2 files changed

+22
-2
lines changed

‎doc/FAQ

Lines changed: 9 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: MonMar 18 14:34:57 EST 2002
4+
Last updated: MonApr 8 23:22:06 EDT 2002
55

66
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77

@@ -91,6 +91,7 @@
9191
4.22) Why are my subqueries using IN so slow?
9292
4.23) How do I perform an outer join?
9393
4.24) How do I perform queries using multiple databases?
94+
4.25) How do I return multiple rows or columns from a function?
9495

9596
Extending PostgreSQL
9697

@@ -1017,6 +1018,13 @@ SELECT *
10171018
databases and merge the information that way.
10181019
_________________________________________________________________
10191020

1021+
4.25) How do I return multiple rows or columns from a function?
1022+
1023+
You can return result sets from PL/pgSQL functions using refcursors.
1024+
See
1025+
http://candle.pha.pa.us/main/writings/pgsql/sgml/plpgsql-cursors.html,
1026+
section 23.7.3.3.
1027+
10201028
Extending PostgreSQL
10211029

10221030
5.1) I wrote a user-defined function. When I run it in psql, why does it

‎doc/src/FAQ/FAQ.html

Lines changed: 13 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@
1414
alink="#0000ff">
1515
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1616

17-
<P>Last updated: MonMar 18 14:34:57 EST 2002</P>
17+
<P>Last updated: MonApr 8 23:22:06 EDT 2002</P>
1818

1919
<P>Current maintainer: Bruce Momjian (<Ahref=
2020
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
@@ -137,6 +137,8 @@ <H2 align="center">Operational Questions</H2>
137137
<Ahref="#4.23">4.23</A>) How do I perform an outer join?<BR>
138138
<Ahref="#4.24">4.24</A>) How do I perform queries using multiple
139139
databases?<BR>
140+
<Ahref="#4.25">4.25</A>) How do I return multiple rows or columns
141+
from a function?<BR>
140142

141143

142144
<H2align="center">Extending PostgreSQL</H2>
@@ -1299,6 +1301,16 @@ <H4><A name="4.24">4.24</A>) How do I perform queries using
12991301
different databases and merge the information that way.</P>
13001302
<HR>
13011303

1304+
<H4><Aname="4.25">4.25</A>) How do I return multiple rows or columns
1305+
from a function?</H4>
1306+
1307+
<P>You can return result sets from PL/pgSQL functions using
1308+
<i>refcursors</i>. See<a
1309+
href="http://candle.pha.pa.us/main/writings/pgsql/sgml/plpgsql-cursors.html">
1310+
http://candle.pha.pa.us/main/writings/pgsql/sgml/plpgsql-cursors.html,</a>
1311+
section 23.7.3.3.</P>
1312+
1313+
13021314
<H2align="center">Extending PostgreSQL</H2>
13031315

13041316
<H4><Aname="5.1">5.1</A>) I wrote a user-defined function. When I

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp