Re: [GENERAL] Create recursive view schema.name

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

Re: [GENERAL] Create recursive view schema.name

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

[GENERAL] Create recursive view schema.name

Hi all, I'm using PG 9.6, learning the "recursive" queries. 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: CREATE OR REPLACE