Enhanced cycle mark values
authorPeter Eisentraut <peter@eisentraut.org>
Sat, 27 Feb 2021 07:11:14 +0000 (08:11 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Sat, 27 Feb 2021 07:13:24 +0000 (08:13 +0100)
commitf4adc41c4f92cc91d507b19e397140c35bb9fd71
tree387b6ecdd5e9b4547d887b73f01689aa954f177d
parent4e90052c46c7751779ed83627676ed5e74ebe6d4
Enhanced cycle mark values

Per SQL:202x draft, in the CYCLE clause of a recursive query, the
cycle mark values can be of type boolean and can be omitted, in which
case they default to TRUE and FALSE.

Reviewed-by: Vik Fearing <vik@postgresfriends.org>
Discussion: https://www.postgresql.org/message-id/flat/db80ceee-6f97-9b4a-8ee8-3ba0c58e5be2@2ndquadrant.com
doc/src/sgml/queries.sgml
doc/src/sgml/ref/select.sgml
src/backend/catalog/sql_features.txt
src/backend/parser/gram.y
src/backend/utils/adt/ruleutils.c
src/test/regress/expected/with.out
src/test/regress/sql/with.sql