Extend ExecMakeFunctionResult() to support set-returning functions that return
Tom Lane <tgl@sss.pgh.pa.us>
Extend ExecMakeFunctionResult() to support set-returning functions that return via a tuplestore instead of value-per-call. Refactor a few things to reduce ensuing code duplication with nodeFunctionscan.c. This represents the reasonably noncontroversial part of my proposed patch to switch SQL functions over to returning tuplestores. For the moment, SQL functions still do things the old way. However, this change enables PL SRFs to be called in targetlists (observe changes in plperl regression results).
Files
| Path | Change | +/− |
|---|---|---|
| contrib/tablefunc/tablefunc.c | modified | +7 −5 |
| doc/src/sgml/plpgsql.sgml | modified | +1 −5 |
| src/backend/executor/execQual.c | modified | +328 −50 |
| src/backend/executor/execTuples.c | modified | +28 −1 |
| src/backend/executor/nodeFunctionscan.c | modified | +6 −77 |
| src/backend/utils/fmgr/README | modified | +2 −3 |
| src/include/executor/executor.h | modified | +2 −9 |
| src/include/executor/tuptable.h | modified | +2 −1 |
| src/include/nodes/execnodes.h | modified | +24 −7 |
| src/pl/plperl/expected/plperl.out | modified | +40 −7 |