| From: | Edson Richter <richter(at)simkorp(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Enums documentation "glitch" |
| Date: | 2012-07-29 18:48:52 |
| Message-ID: | 50158594.7010105@simkorp.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
--
*Edson Carlos Ericksson Richter*
/SimKorp Informática Ltda/
Fone: (51) 3366-7964
Celular: (51)9318-9766/(51) 8585-0796
Embedded Image
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2012-07-29 18:56:49 | Re: Enums documentation "glitch" |
| Previous Message | Guillermo Echevarria Quintana-Gurt | 2012-07-29 18:30:23 | password help |