Re: Enums documentation "glitch"
От | David Johnston |
---|---|
Тема | Re: Enums documentation "glitch" |
Дата | |
Msg-id | CC38BC34-2137-4E85-B5DB-EFE9ECC5BE01@yahoo.com обсуждение исходный текст |
Ответ на | Re: Enums documentation "glitch" (Edson Richter <edsonrichter@hotmail.com>) |
Список | pgsql-general |
Resending, sent with wrong sender at first (sorry, I'll be more careful before sending with wrong e-mail address)...Em 29/07/2012 15:48, Edson Richter escreveu:In "CREATE TYPE" documentation, we see the following paragraph:
"Enumerated TypesThe 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):
"8.7.4. Implementation DetailsAn 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?
Regards,
Technically "...less than 64..." is the same as "...at most 63..."
But the different wording is confusing...
David J.
В списке pgsql-general по дате отправления: