pgsql-server/ oc/src/sgml/plpgsql.sgml rc/pl/p ...

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian(at)postgresql(dot)org 02/08/20 01:28:24

Modified files:
doc/src/sgml : plpgsql.sgml
src/pl/plpgsql/src: pl_exec.c
src/test/regress/expected: plpgsql.out
src/test/regress/sql: plpgsql.sql

Log message:
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