Commit47c427d

committed

docs: improve 'capitals' inheritance example

Adds constraints and improves wording.Reported-by: 2552891@gmail.comDiscussion:https://postgr.es/m/159586122762.680.1361378513036616007@wrigleys.postgresql.orgBackpatch-through: 9.5

1 parent243a3b9 commit47c427dCopy full SHA for 47c427d

File tree

-2

lines changed

-2

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -616,7 +616,7 @@ CREATE TABLE cities (`
`616`	`616`	`);`
`617`	`617`
`618`	`618`	`CREATE TABLE capitals (`
`619`		`- state char(2)`
	`619`	`+ state char(2) UNIQUE NOT NULL`
`620`	`620`	`) INHERITS (cities);`
`621`	`621`	`</programlisting>`
`622`	`622`	`</para>`
`@@ -630,7 +630,8 @@ CREATE TABLE capitals (`
`630`	`630`	`<type>text</type>, a native <productname>PostgreSQL</productname>`
`631`	`631`	`type for variable length character strings. The`
`632`	`632`	`<classname>capitals</classname> table has`
`633`		`- an extra column, <structfield>state</structfield>, which shows their states. In`
	`633`	`+ an additional column, <structfield>state</structfield>, which shows its`
	`634`	`+ state abbreviation. In`
`634`	`635`	`<productname>PostgreSQL</productname>, a table can inherit from`
`635`	`636`	`zero or more other tables.`
`636`	`637`	`</para>`

Comments

(0)