From 6ac697f18065f41cad4e3c63a674575b711e03b6 Mon Sep 17 00:00:00 2001 From: Bruce Momjian <bruce@momjian.us> Date: Tue, 10 Nov 2009 02:09:54 +0000 Subject: [PATCH] PL/pgSQL FOUND Document that GET DIAGNOSTICS is affected by EXECUTE, while FOUND is not. --- doc/src/sgml/plpgsql.sgml | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 401d1216e4..51cdf7ccc3 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.144 2009/11/05 16:58:36 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.145 2009/11/10 02:09:54 momjian Exp $ --> <chapter id="plpgsql"> <title><application>PL/pgSQL</application> - <acronym>SQL</acronym> Procedural Language</title> @@ -1365,7 +1365,9 @@ GET DIAGNOSTICS integer_var = ROW_COUNT; <literal>FOUND</literal> is a local variable within each <application>PL/pgSQL</application> function; any changes to it - affect only the current function. + affect only the current function. <literal>FOUND</literal> is not + affected by <literal>EXECUTE</literal>, while <command>GET + DIAGNOSTICS</command> is effected. </para> </sect2> -- 2.40.0