Commit5a6ba62

committed

Document that CREATE VIEW that uses "*" for the column list will not

auto-add columns later added to the base table.

1 parentd56d246 commit5a6ba62Copy full SHA for 5a6ba62

File tree

-0

lines changed

-0

lines changed

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -173,6 +173,10 @@ CREATE VIEW comedies AS`
`173`	`173`	`FROM films`
`174`	`174`	`WHERE kind = 'Comedy';`
`175`	`175`	`</programlisting>`
	`176`	`+ This will create a view containing the columns that are in the`
	`177`	`+ <literal>film</> table at the time of view creation. Though`
	`178`	`+ <literal>*</> was used to create the view, columns added later to`
	`179`	`+ the table will not be part of the view.`
`176`	`180`	`</para>`
`177`	`181`	`</refsect1>`
`178`	`182`

Comments

(0)