File tree Expand file tree Collapse file tree 1 file changed +14
-6
lines changed
Filter options
Expand file tree Collapse file tree 1 file changed +14
-6
lines changed
Original file line number Diff line number Diff line change @@ -3059,19 +3059,27 @@ SELECT person.name, holidays.num_weeks FROM person, holidays
3059
3059
<sect2>
3060
3060
<title>Implementation Details</title>
3061
3061
3062
+ <para>
3063
+ Enum labels are case sensitive, so
3064
+ <type>'happy'</type> is not the same as <type>'HAPPY'</type>.
3065
+ White space in the labels is significant too.
3066
+ </para>
3067
+
3068
+ <para>
3069
+ Although enum types are primarily intended for static sets of values,
3070
+ there is support for adding new values to an existing enum type, and for
3071
+ renaming values (see <xref linkend="sql-altertype"/>). Existing values
3072
+ cannot be removed from an enum type, nor can the sort ordering of such
3073
+ values be changed, short of dropping and re-creating the enum type.
3074
+ </para>
3075
+
3062
3076
<para>
3063
3077
An enum value occupies four bytes on disk. The length of an enum
3064
3078
value's textual label is limited by the <symbol>NAMEDATALEN</symbol>
3065
3079
setting compiled into <productname>PostgreSQL</productname>; in standard
3066
3080
builds this means at most 63 bytes.
3067
3081
</para>
3068
3082
3069
- <para>
3070
- Enum labels are case sensitive, so
3071
- <type>'happy'</type> is not the same as <type>'HAPPY'</type>.
3072
- White space in the labels is significant too.
3073
- </para>
3074
-
3075
3083
<para>
3076
3084
The translations from internal enum values to textual labels are
3077
3085
kept in the system catalog
You can’t perform that action at this time.
0 commit comments