On Jul 29, 2012, at 14:56, Edson Richter <edsonrich...@hotmail.com> wrote:
> 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 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): >> >> "8.7.4. Implementation Details >> 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? > > Regards, > > Technically "...less than 64..." is the same as "...at most 63..." But the different wording is confusing... David J.
