public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Andreas Kretschmer <[email protected]>
Cc: [email protected]
Subject: Re: documentation for WITH RECURSIVE
Date: Mon, 18 Nov 2019 12:32:08 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Andreas Kretschmer <[email protected]> writes:
> One of our customers had problems with the syntax of WITH RECURSIVE. He 
> suggested that the documentation should be improved, maybe with this 
> sentence:
> "If any of the CTEs is recursive, the recursive keywork must be present 
> after with", so to make sure that it does not refer to just one of the 
> named subqueries.

Hm, was this intended for the SELECT man page (presumably in the
"WITH Clause" section), or for section 7.8?

In the SELECT page, I'd be inclined to put it after the para about
"queries need not be ordered" and phrase it more like

  If there are multiple queries in the WITH clause, RECURSIVE can
  be written only once, immediately after WITH.  It applies to all
  queries in the WITH clause (but has no effect on queries that do
  not use either of these features).

			regards, tom lane

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: documentation for WITH RECURSIVE
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox