postgres.git / summary / log / commit / refs

commit    7e89e61d1b2fbb3851e4da64b3dbd971a3cf0fa6
Author:   Peter Eisentraut <peter_e@gmx.net>
Date:     Tue Nov 13 09:42:43 2018 +0000
First released in: 12.0, 9.4.21, 9.5.16, 9.6.12, 10.7, 11.2

    doc: Clarify CREATE TYPE ENUM documentation
    
    The documentation claimed that an enum type requires "one or more"
    labels, but since 1fd9883ff49, zero labels are also allowed.
    
    Reported-by: Lukas Eder <lukas.eder@gmail.com>
    Bug: #15356


 doc/src/sgml/ref/create_type.sgml | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml
index 7146c4a27b7..e0e005b7cf6 100644
--- a/doc/src/sgml/ref/create_type.sgml
+++ b/doc/src/sgml/ref/create_type.sgml
@@ -117,9 +117,12 @@ CREATE TYPE <replaceable class="parameter">name</replaceable>
    <para>
     The second form of <command>CREATE TYPE</command> creates an enumerated
     (enum) type, as described in <xref linkend="datatype-enum">.
-    Enum types take a list of one or more quoted labels, each of which
+    Enum types take a list of quoted labels, each of which
     must be less than <symbol>NAMEDATALEN</symbol> bytes long (64 bytes in a
-    standard <productname>PostgreSQL</productname> build).
+    standard <productname>PostgreSQL</productname> build).  (It is possible to
+    create an enumerated type with zero labels, but such a type cannot be used
+    to hold values before at least one label is added using <xref
+    linkend="sql-altertype">.)
    </para>
   </refsect2>
 


[parent: 0064d0e9f44f]