Tom Lane <t...@sss.pgh.pa.us> 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 just > has the base name of the view; but since CTE names can't be qualified, > that's not that hard to guess. Short answer is that you don't qualify the > view's internal self-reference, even if you are using a schema name in the > CREATE.
Thank you Tom, it works. I agree with you that the doc could/should be fixed/enhanced, because the explanation of "name" is immediately following the snippet you cited, and it says "The name (optionally schema-qualified) of a view to be created": it would never occurred to me that I could use a not-qualified name within the view. bye, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depero, 1929. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
