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

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@postgresql.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