Horton

SEARCH and CYCLE clauses

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 3696a600e2292d43c00949ddf0352e4ebb487e5b
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2021-02-01T13:32:51Z
Releases: 14.0 
SEARCH and CYCLE clauses

This adds the SQL standard feature that adds the SEARCH and CYCLE
clauses to recursive queries to be able to do produce breadth- or
depth-first search orders and detect cycles.  These clauses can be
rewritten into queries using existing syntax, and that is what this
patch does in the rewriter.

Reviewed-by: Vik Fearing <vik@postgresfriends.org>
Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/db80ceee-6f97-9b4a-8ee8-3ba0c58e5be2@2ndquadrant.com

Files

PathChange+/−
doc/src/sgml/queries.sgml modified +63 −1
doc/src/sgml/ref/select.sgml modified +44 −0
src/backend/catalog/dependency.c modified +15 −0
src/backend/nodes/copyfuncs.c modified +40 −0
src/backend/nodes/equalfuncs.c modified +36 −0
src/backend/nodes/nodeFuncs.c modified +41 −1
src/backend/nodes/outfuncs.c modified +36 −0
src/backend/nodes/readfuncs.c modified +44 −0
src/backend/parser/analyze.c modified +29 −18
src/backend/parser/gram.y modified +53 −5
src/backend/parser/parse_agg.c modified +7 −0
src/backend/parser/parse_cte.c modified +193 −0
src/backend/parser/parse_expr.c modified +4 −0
src/backend/parser/parse_func.c modified +3 −0
src/backend/parser/parse_relation.c modified +49 −5
src/backend/parser/parse_target.c modified +16 −1
src/backend/rewrite/Makefile modified +1 −0
src/backend/rewrite/rewriteHandler.c modified +18 −0
src/backend/rewrite/rewriteSearchCycle.c added +668 −0
src/backend/utils/adt/ruleutils.c modified +47 −0
src/include/nodes/nodes.h modified +2 −0
src/include/nodes/parsenodes.h modified +28 −2
src/include/parser/analyze.h modified +2 −0
src/include/parser/kwlist.h modified +2 −0
src/include/parser/parse_node.h modified +2 −0
src/include/rewrite/rewriteSearchCycle.h added +21 −0
src/test/regress/expected/with.out modified +558 −0
src/test/regress/sql/with.sql modified +279 −0

Documentation touched

Discussion