Tom Lane writes:
> The manual says
> CREATE RECURSIVE VIEW name (columns) AS SELECT ...;
> is equivalent to
> CREATE VIEW name AS WITH RECURSIVE name (columns) AS (SELECT ...)
> SELECT columns FROM name;
>
> I guess it could be more explicit about the fact that the implied CTE
Lele Gaifax writes:
> I have a working recursive-CTE query, and I tried wrapping it in a view:
> reading the documentation I found the "CREATE RECURSIVE VIEW" form, so I tried
> it.
> It works as far as I use a "simple" name for the view:
> but I get an error when I create it in a specific schema
