diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 02eaedf..a88a01c 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -2975,19 +2975,19 @@ SELECT person.name, holidays.num_weeks FROM person, holidays An enum value occupies four bytes on disk. The length of an enum - value's textual label is limited by the NAMEDATALEN + value is limited by the NAMEDATALEN setting compiled into PostgreSQL; in standard builds this means at most 63 bytes. - Enum labels are case sensitive, so + Enum values are case sensitive, so 'happy' is not the same as 'HAPPY'. - White space in the labels is significant too. + White space in the value is significant too. - The translations from internal enum values to textual labels are + The translations from internal enum values to textual values are kept in the system catalog pg_enum. Querying this catalog directly can be useful. diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index a3c75b5..c48b756 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -25,7 +25,7 @@ CREATE TYPE name AS ( [ attribute_name data_type [, ... ] ] ) CREATE TYPE name AS ENUM - ( [ 'label' [, ... ] ] ) + ( [ 'value' [, ... ] ] ) CREATE TYPE name ( INPUT = input_function, @@ -90,7 +90,7 @@ CREATE TYPE name The second form of CREATE TYPE creates an enumerated (enum) type, as described in . - Enum types take a list of one or more quoted labels, each of which + Enum types take a list of one or more quoted values, each of which must be less than NAMEDATALEN bytes long (64 in a standard PostgreSQL build). @@ -426,10 +426,10 @@ CREATE TYPE name - label + value - A string literal representing the textual label associated with + A string literal representing the textual value associated with one value of an enum type.