]> granicus.if.org Git - postgresql/commit
This patch improves the behavior of FOUND in PL/PgSQL. In Oracle,
authorBruce Momjian <bruce@momjian.us>
Tue, 20 Aug 2002 05:28:24 +0000 (05:28 +0000)
committerBruce Momjian <bruce@momjian.us>
Tue, 20 Aug 2002 05:28:24 +0000 (05:28 +0000)
commitebe1be1321fb88d7c085d39e4f01efcd352ed119
treec8ea6dfd750c322a5e1b19704e34a39f9f83e51b
parent818a33e4d5d0394c42234da4acf5291d7e272c84
This patch improves the behavior of FOUND in PL/PgSQL. In Oracle,
FOUND is set whenever a SELECT INTO returns > 0 rows, *or* when an
INSERT, UPDATE, or DELETE affects > 0 rows. We implemented the first
part of this behavior, but not the second.

I also improved the documentation on the various situations in which
FOUND can be set (excluding inside FOR loops, which I still need to
think about), and added some regression tests for this behavior.

Neil Conway
doc/src/sgml/plpgsql.sgml
src/pl/plpgsql/src/pl_exec.c
src/test/regress/expected/plpgsql.out
src/test/regress/sql/plpgsql.sql