Horton

documentation for WITH RECURSIVE

Andreas Kretschmer <andreas@a-kretschmer.de>

View thread View on postgr.es
From: Andreas Kretschmer <andreas@a-kretschmer.de>
To: pgsql-docs@lists.postgresql.org
Date: 2019-11-18T14:36:24Z
Lists: pgsql-docs 
Hi,

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.



Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

Commits

  1. Doc: clarify use of RECURSIVE in WITH.