Re: Enums documentation "glitch"

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.

In response to

Responses

Browse pgsql-general by date

  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"