Heikki Linnakangas wrote:
>> I found the typo in
>> http://www.postgresql.org/docs/8.3/static/datatype-enum.html .
>>
>>> 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.
>>
>> Correct is that the NAMEDATALEN means 64 bytes in standard builds.
>
> No. NAMEDATALEN is 64 bytes, but the 64th byte is reserved for the
> null-terminator, so the string stored can be at most 63 bytes long.
Ok.
But, it's described that NAMEDATALEN is 64 bytes in
http://www.postgresql.org/docs/8.3/static/sql-createtype.html.
This conflict can confuse the user. So, should we unite the
descriptions of the number of bytes for NAMEDATALEN?
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
TEL (03)5860-5115
FAX (03)5463-5490