postgres.git / summary / log / commit / refs

commit    a76d83a00a9151dda2d1258100421ba493d6229a
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Mon Aug 31 17:43:04 2020 +0000
First released in: 14.0, 9.5.24, 9.6.20, 10.15, 11.10, 12.5, 13.0

    docs:  improve 'capitals' inheritance example
    
    Adds constraints and improves wording.
    
    Reported-by: 2552891@gmail.com
    
    Discussion: https://postgr.es/m/159586122762.680.1361378513036616007@wrigleys.postgresql.org
    
    Backpatch-through: 9.5


 doc/src/sgml/advanced.sgml | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml
index 1586021c2e7..7bead13c997 100644
--- a/doc/src/sgml/advanced.sgml
+++ b/doc/src/sgml/advanced.sgml
@@ -617,7 +617,7 @@ CREATE TABLE cities (
 );
 
 CREATE TABLE capitals (
-  state      char(2)
+  state      char(2) UNIQUE NOT NULL
 ) INHERITS (cities);
 </programlisting>
    </para>
@@ -631,7 +631,8 @@ CREATE TABLE capitals (
     <type>text</type>, a native <productname>PostgreSQL</productname>
     type for variable length character strings.  The
     <classname>capitals</> table has
-    an extra column, <structfield>state</>, which shows their states.  In
+    an additional column, <structfield>state</>, which shows its
+    state abbreviation.  In
     <productname>PostgreSQL</productname>, a table can inherit from
     zero or more other tables.
    </para>


[parent: ae6c6c255648]