Commit3a1f8cd

committed

Add an example of attaching a default value to an updatable view.

This is probably the single most useful thing that ALTER VIEW can do,particularly now that we have auto-updatable views. So show an explicitexample.

1 parent0343a59 commit3a1f8cdCopy full SHA for 3a1f8cd

File tree

+13

-1

lines changed

+13

-1

lines changed

Lines changed: 13 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -154,7 +154,19 @@ ALTER VIEW [ IF EXISTS ] <replaceable class="parameter">name</replaceable> RESET`
`154`	`154`	`<literal>bar</literal>:`
`155`	`155`	`<programlisting>`
`156`	`156`	`ALTER VIEW foo RENAME TO bar;`
`157`		`-</programlisting></para>`
	`157`	`+</programlisting>`
	`158`	`+ </para>`
	`159`	`+`
	`160`	`+ <para>`
	`161`	`+ To attach a default column value to an updatable view:`
	`162`	`+<programlisting>`
	`163`	`+CREATE TABLE base_table (id int, ts timestamptz);`
	`164`	`+CREATE VIEW a_view AS SELECT * FROM base_table;`
	`165`	`+ALTER VIEW a_view ALTER COLUMN ts SET DEFAULT now();`
	`166`	`+INSERT INTO base_table(id) VALUES(1); -- ts will receive a NULL`
	`167`	`+INSERT INTO a_view(id) VALUES(2); -- ts will receive the current time`
	`168`	`+</programlisting>`
	`169`	`+ </para>`
`158`	`170`	`</refsect1>`
`159`	`171`
`160`	`172`	`<refsect1>`

Comments

(0)