postgres.git / summary / log / commit / refs

commit    390301ce630c9bbececef169130694acc06fafe2
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 5a09f1942a7..3f544138877 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: 8af1511e9cb5]