Commit5b80588

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 parent787b3fd commit5b80588Copy full SHA for 5b80588

File tree

-0

lines changed

-0

lines changed

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -273,6 +273,14 @@ TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ]`
`273`	`273`	`that are earlier in the <literal>WITH</literal> list.`
`274`	`274`	`</para>`
`275`	`275`
	`276`	`+ <para>`
	`277`	`+ When there are multiple queries in the <literal>WITH</literal>`
	`278`	`+ clause, <literal>RECURSIVE</literal> should be written only once,`
	`279`	`+ immediately after <literal>WITH</literal>. It applies to all queries`
	`280`	`+ in the <literal>WITH</literal> clause, though it has no effect on`
	`281`	`+ queries that do not use recursion or forward references.`
	`282`	`+ </para>`
	`283`	`+`
`276`	`284`	`<para>`
`277`	`285`	`The primary query and the <literal>WITH</literal> queries are all`
`278`	`286`	`(notionally) executed at the same time. This implies that the effects of`

Comments

(0)