PL/pgSQL functions can return sets. Neil Conway's patch, modified so
Tom Lane <tgl@sss.pgh.pa.us>
PL/pgSQL functions can return sets. Neil Conway's patch, modified so that the functionality is available to anyone via ReturnSetInfo, rather than hard-wiring it to PL/pgSQL.
Files
| Path | Change | +/− |
|---|---|---|
| contrib/intagg/int_aggregate.c | modified | +13 −22 |
| doc/src/sgml/plpgsql.sgml | modified | +63 −23 |
| doc/src/sgml/release.sgml | modified | +2 −1 |
| doc/src/sgml/runtime.sgml | modified | +3 −2 |
| doc/src/sgml/xfunc.sgml | modified | +2 −4 |
| src/backend/executor/execQual.c | modified | +282 −47 |
| src/backend/executor/nodeFunctionscan.c | modified | +30 −141 |
| src/backend/utils/fmgr/README | modified | +40 −15 |
| src/include/executor/executor.h | modified | +4 −1 |
| src/include/fmgr.h | modified | +2 −3 |
| src/include/nodes/execnodes.h | modified | +23 −24 |
| src/pl/plpgsql/src/gram.y | modified | +68 −54 |
| src/pl/plpgsql/src/Makefile | modified | +2 −2 |
| src/pl/plpgsql/src/pl_comp.c | modified | +2 −6 |
| src/pl/plpgsql/src/pl_exec.c | modified | +218 −35 |
| src/pl/plpgsql/src/pl_funcs.c | modified | +21 −9 |
| src/pl/plpgsql/src/pl_handler.c | modified | +1 −8 |
| src/pl/plpgsql/src/plpgsql.h | modified | +21 −4 |
| src/pl/plpgsql/src/scan.l | modified | +41 −5 |
| src/test/regress/expected/plpgsql.out | modified | +72 −1 |
| src/test/regress/sql/plpgsql.sql | modified | +47 −1 |