In "CREATE TYPE" documentation, we see the following paragraph: "Enumerated Types The second form of CREATE TYPE creates an enumerated
(enum) type, as described in Section
8.7. Enum types take a list of one or more quoted labels,
each of which must be less than NAMEDATALEN bytes long (64 in a
standard PostgreSQL build)." In section 8.7 we find a conflicting statement (ok, is
just 1 character, but still):
An enum value occupies four bytes on disk. The length of
an enum value's textual label is limited by the NAMEDATALEN
setting compiled into PostgreSQL; in standard builds this means at
most 63 bytes." What is the correct one: 63 or 64 bytes? --
|