diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-09-06 13:41:28 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-09-06 13:42:08 -0400 |
| commit | 6f94280dee9f8b6c511f00a50531b981faa73b54 (patch) | |
| tree | 794303aeced765a0c622924b3e608a721a4483dd /doc/src | |
| parent | ae92eff6b93c6ee18ca5c48958c355f5a448f8f5 (diff) | |
| download | postgresql-6f94280dee9f8b6c511f00a50531b981faa73b54.tar.gz postgresql-6f94280dee9f8b6c511f00a50531b981faa73b54.zip | |
Document PERFORM limitation when using WITH queries.
Backpatch to 9.0 and 9.1.
Report from depstein@alliedtesting.com.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 08c3658d5e3..a2482de2b95 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -940,6 +940,9 @@ PERFORM <replaceable>query</replaceable>; result. Write the <replaceable>query</replaceable> the same way you would write an SQL <command>SELECT</> command, but replace the initial keyword <command>SELECT</> with <command>PERFORM</command>. + For <keyword>WITH</> queries, use <keyword>PERFORM</> and then + place the query in parentheses. (In this case, the query can only + return one row.) <application>PL/pgSQL</application> variables will be substituted into the query just as for commands that return no result, and the plan is cached in the same way. Also, the special variable |