diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2018-11-13 10:42:43 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2018-11-20 09:50:50 +0100 |
| commit | 8345bd40acdad115e9cafac744fbe565dedbd68e (patch) | |
| tree | c6270a2e32eb2aa85bbea786febc4e1b3497ff07 /doc/src | |
| parent | ced3aaa5b67870c907905203f0653524c622c163 (diff) | |
| download | postgresql-8345bd40acdad115e9cafac744fbe565dedbd68e.tar.gz postgresql-8345bd40acdad115e9cafac744fbe565dedbd68e.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_type.sgml | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index a6a4644d590..da08d3d01af 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> |