diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-09-24 18:54:14 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-09-24 18:54:14 +0000 |
| commit | 12a2121c75ee2078bb23f4dfecb87bcf674017f2 (patch) | |
| tree | 3a1fd685017333a9023e6b3a7a0e1e40fcc31301 | |
| parent | ae72283816e7466ee9e7e93c9d36f5f5c362680f (diff) | |
| download | postgresql-12a2121c75ee2078bb23f4dfecb87bcf674017f2.tar.gz postgresql-12a2121c75ee2078bb23f4dfecb87bcf674017f2.zip | |
Fix slightly misleading description of PERFORM syntax.
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index ff2b4b2a749..3e87f76f5b3 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.46 2004/08/16 17:52:06 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.47 2004/09/24 18:54:14 tgl Exp $ --> <chapter id="plpgsql"> @@ -1073,10 +1073,12 @@ END; PERFORM <replaceable>query</replaceable>; </synopsis> - This executes <replaceable>query</replaceable>, which must be a - <command>SELECT</command> statement, and discards the - result. <application>PL/pgSQL</application> variables are - substituted in the query as usual. Also, the special variable + This executes <replaceable>query</replaceable> and discards the + result. Write the <replaceable>query</replaceable> the same + way as you would in an SQL <command>SELECT</> command, but replace the + initial keyword <command>SELECT</> with <command>PERFORM</command>. + <application>PL/pgSQL</application> variables will be + substituted into the query as usual. Also, the special variable <literal>FOUND</literal> is set to true if the query produced at least one row or false if it produced no rows. </para> |