From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Enums documentation "glitch" |
Date: | 2012-07-29 19:07:51 |
Message-ID: | CC38BC34-2137-4E85-B5DB-EFE9ECC5BE01@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jul 29, 2012, at 14:56, Edson Richter <edsonrichter(at)hotmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2012-07-30 04:59:18 | Re: password help |
Previous Message | Edson Richter | 2012-07-29 18:56:49 | Re: Enums documentation "glitch" |