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