Support INSERT/UPDATE/DELETE RETURNING in plpgsql, with rowcount checking
Tom Lane <tgl@sss.pgh.pa.us>
Support INSERT/UPDATE/DELETE RETURNING in plpgsql, with rowcount checking as per yesterday's proposal. Also make things a tad more orthogonal by adding the recent STRICT addition to EXECUTE INTO. Jonah Harris and Tom Lane
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/plpgsql.sgml | modified | +185 −109 |
| src/pl/plpgsql/src/gram.y | modified | +104 −145 |
| src/pl/plpgsql/src/pl_exec.c | modified | +216 −146 |
| src/pl/plpgsql/src/pl_funcs.c | modified | +25 −33 |
| src/pl/plpgsql/src/plpgsql.h | modified | +12 −16 |
| src/pl/plpgsql/src/scan.l | modified | +2 −2 |
| src/test/regress/expected/plpgsql.out | modified | +140 −0 |
| src/test/regress/sql/plpgsql.sql | modified | +116 −0 |