Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if more or
Bruce Momjian <bruce@momjian.us>
Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if more or less than one row is returned by the SELECT, for Oracle PL/SQL compatibility. Improve SELECT INTO documentation. Matt Miller
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/plpgsql.sgml | modified | +29 −33 |
| src/pl/plpgsql/src/gram.y | modified | +9 −1 |
| src/pl/plpgsql/src/plerrcodes.h | modified | +11 −1 |
| src/pl/plpgsql/src/pl_exec.c | modified | +25 −7 |
| src/pl/plpgsql/src/plpgsql.h | modified | +2 −1 |
| src/pl/plpgsql/src/scan.l | modified | +2 −1 |