Search Postgresql Archives

Enums documentation "glitch"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

--

Edson Carlos Ericksson Richter
SimKorp Informática Ltda
Fone: (51) 3366-7964
Celular: (51)9318-9766/(51) 8585-0796
Embedded Image


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux