Horton

Re-implement LIMIT/OFFSET as a plan node type, instead of a hack in

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 2f35b4efdbec6c161ca9bd491d6345134910c425
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2000-10-26T21:38:24Z
Releases: 7.1.1 
Re-implement LIMIT/OFFSET as a plan node type, instead of a hack in
ExecutorRun.  This allows LIMIT to work in a view.  Also, LIMIT in a
cursor declaration will behave in a reasonable fashion, whereas before
it was overridden by the FETCH count.

Files

PathChange+/−
src/backend/commands/command.c modified +4 −21
src/backend/commands/explain.c modified +4 −1
src/backend/executor/execAmi.c modified +6 −1
src/backend/executor/execMain.c modified +20 −127
src/backend/executor/execProcnode.c modified +17 −1
src/backend/executor/execTuples.c modified +9 −1
src/backend/executor/functions.c modified +2 −5
src/backend/executor/Makefile modified +3 −3
src/backend/executor/nodeLimit.c added +324 −0
src/backend/executor/spi.c modified +2 −37
src/backend/nodes/copyfuncs.c modified +29 −1
src/backend/nodes/outfuncs.c modified +16 −1
src/backend/nodes/print.c modified +3 −1
src/backend/optimizer/plan/createplan.c modified +22 −1
src/backend/optimizer/plan/planner.c modified +19 −9
src/backend/optimizer/plan/setrefs.c modified +2 −1
src/backend/optimizer/plan/subselect.c modified +2 −1
src/backend/rewrite/rewriteDefine.c modified +1 −7
src/backend/tcop/pquery.c modified +2 −3
src/backend/utils/adt/ruleutils.c modified +15 −3
src/include/executor/executor.h modified +2 −2
src/include/executor/nodeLimit.h added +25 −0
src/include/nodes/execnodes.h modified +23 −1
src/include/nodes/nodes.h modified +3 −2
src/include/nodes/plannodes.h modified +14 −1
src/include/optimizer/planmain.h modified +3 −1