postgres.git / summary / log / commit / refs

commit    5a6ba62be5364dbf973fd9b8631fd60acda03440
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Tue Feb 01 22:17:34 2011 +0000

    Document that CREATE VIEW that uses "*" for the column list will not
    auto-add columns later added to the base table.


 doc/src/sgml/ref/create_view.sgml | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml
index dd155078111..417f8c38e7e 100644
--- a/doc/src/sgml/ref/create_view.sgml
+++ b/doc/src/sgml/ref/create_view.sgml
@@ -173,6 +173,10 @@ CREATE VIEW comedies AS
     FROM films
     WHERE kind = 'Comedy';
 </programlisting>
+   This will create a view containing the columns that are in the
+   <literal>film</> table at the time of view creation.  Though
+   <literal>*</> was used to create the view, columns added later to
+   the table will not be part of the view.
   </para>
  </refsect1>
 


[parent: d56d246e7018]