diff options
| author | Bruce Momjian <bruce@momjian.us> | 2009-02-05 15:25:49 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2009-02-05 15:25:49 +0000 |
| commit | 8c78f8e65c2f68e946f145770cf24a49ac88c891 (patch) | |
| tree | c420d25be1a8dbbca7ea27187e096bc9f12fdb65 /doc/src | |
| parent | 78cbd498263122fe731a6dd1f31c906042fa2127 (diff) | |
Add PL/PgSQL FOUND and GET DIAGNOSTICS support for RETURN QUERY
statement
Pavel Stehule
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 0e9e43065df..db6d08fd69f 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.137 2009/02/04 21:30:41 alvherre Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.138 2009/02/05 15:25:49 momjian Exp $ --> <chapter id="plpgsql"> <title><application>PL/pgSQL</application> - <acronym>SQL</acronym> Procedural Language</title> @@ -1356,6 +1356,14 @@ GET DIAGNOSTICS integer_var = ROW_COUNT; execution of other statements within the loop body. </para> </listitem> + <listitem> + <para> + A <command>RETURN QUERY</command> and <command>RETURN QUERY + EXECUTE</command> statements set <literal>FOUND</literal> + true if the query returns at least one row, false if no row + is returned. + </para> + </listitem> </itemizedlist> <literal>FOUND</literal> is a local variable within each |