postgres
diff --git a/‎doc/src/sgml/advanced.sgml
Copy file name to clipboardExpand all lines: doc/src/sgml/advanced.sgml
+3-2Lines changed: 3 additions & 2 deletions b/‎doc/src/sgml/advanced.sgml
Copy file name to clipboardExpand all lines: doc/src/sgml/advanced.sgml
+3-2Lines changed: 3 additions & 2 deletions
@@ -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>