postgres.git / summary / log / commit / refs

commit    cf3e2c3983a8d315ab0ab893ff8b83196e7f8164
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue Oct 11 14:08:45 2016 +0000

    Improve documentation for CREATE RECURSIVE VIEW.
    
    It was perhaps not entirely clear that internal self-references shouldn't
    be schema-qualified even if the view name is written with a schema.
    Spell it out.
    
    Discussion: <871sznz69m.fsf@metapensiero.it>


 doc/src/sgml/ref/create_view.sgml | 15 ++++++++++-----
 1 file changed, 10 insertions(+), 5 deletions(-)

diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml
index 2af6f6e028e..a78faf1af58 100644
--- a/doc/src/sgml/ref/create_view.sgml
+++ b/doc/src/sgml/ref/create_view.sgml
@@ -86,13 +86,13 @@ CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW <replaceable class
      <para>
       Creates a recursive view.  The syntax
 <synopsis>
-CREATE RECURSIVE VIEW <replaceable>name</> (<replaceable>columns</>) AS SELECT <replaceable>...</>;
+CREATE RECURSIVE VIEW [ <replaceable>schema</> . ] <replaceable>view_name</> (<replaceable>column_names</>) AS SELECT <replaceable>...</>;
 </synopsis>
       is equivalent to
 <synopsis>
-CREATE VIEW <replaceable>name</> AS WITH RECURSIVE <replaceable>name</> (<replaceable>columns</>) AS (SELECT <replaceable>...</>) SELECT <replaceable>columns</> FROM <replaceable>name</>;
+CREATE VIEW [ <replaceable>schema</> . ] <replaceable>view_name</> AS WITH RECURSIVE <replaceable>view_name</> (<replaceable>column_names</>) AS (SELECT <replaceable>...</>) SELECT <replaceable>column_names</> FROM <replaceable>view_name</>;
 </synopsis>
-      A view column list must be specified for a recursive view.
+      A view column name list must be specified for a recursive view.
      </para>
     </listitem>
    </varlistentry>
@@ -303,11 +303,16 @@ CREATE VIEW comedies AS
   <para>
    Create a recursive view consisting of the numbers from 1 to 100:
 <programlisting>
-CREATE RECURSIVE VIEW nums_1_100 (n) AS
+CREATE RECURSIVE VIEW public.nums_1_100 (n) AS
     VALUES (1)
 UNION ALL
     SELECT n+1 FROM nums_1_100 WHERE n < 100;
-</programlisting></para>
+</programlisting>
+   Notice that although the recursive view's name is schema-qualified in this
+   <command>CREATE</>, its internal self-reference is not schema-qualified.
+   This is because the implicitly-created CTE's name cannot be
+   schema-qualified.
+  </para>
  </refsect1>
 
  <refsect1>


[parent: 455eaf9847ab]