From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Enums documentation "glitch" |
Date: | 2012-07-29 18:56:49 |
Message-ID: | BLU0-SMTP2069332E55E227CB6A3FF2BCFC70@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 Types
>
> The second form of CREATE TYPE creates an enumerated (enum) type, as
> described in Section 8.7
> <http://www.postgresql.org/docs/9.1/static/datatype-enum.html>. 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,
Edson.
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2012-07-29 19:07:51 | Re: Enums documentation "glitch" |
Previous Message | Edson Richter | 2012-07-29 18:48:52 | Enums documentation "glitch" |