Commitf115590

committed

Doc: clarify use of RECURSIVE in WITH.

Apparently some people misinterpreted the syntax as being thatRECURSIVE is a prefix of individual WITH queries. It's a modifierfor the WITH clause as a whole, so state that more clearly.Discussion:https://postgr.es/m/ca53c6ce-a0c6-b14a-a8e3-162f0b2cc119@a-kretschmer.de

1 parentd30e0ed commitf115590Copy full SHA for f115590

File tree

-0

lines changed

-0

lines changed

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -281,6 +281,14 @@ TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ]`
`281`	`281`	`reads all or any of their output.`
`282`	`282`	`</para>`
`283`	`283`
	`284`	`+ <para>`
	`285`	`+ When there are multiple queries in the <literal>WITH</literal>`
	`286`	`+ clause, <literal>RECURSIVE</literal> should be written only once,`
	`287`	`+ immediately after <literal>WITH</literal>. It applies to all queries`
	`288`	`+ in the <literal>WITH</literal> clause, though it has no effect on`
	`289`	`+ queries that do not use recursion or forward references.`
	`290`	`+ </para>`
	`291`	`+`
`284`	`292`	`<para>`
`285`	`293`	`The primary query and the <literal>WITH</literal> queries are all`
`286`	`294`	`(notionally) executed at the same time. This implies that the effects of`

Comments

(0)