From f4a5f0ba7141f0e26e748ec27c6ba2e213e65c57 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Sun, 3 Dec 2000 14:47:18 +0000 Subject: [PATCH] Clarify the allowed length of the text data type. --- doc/src/sgml/datatype.sgml | 15 +++++++-------- 1 file changed, 7 insertions(+), 8 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index aff3f6c1db..62bfcb0f80 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -497,9 +497,9 @@ CREATE TABLE tablename ( text - (4+length) bytes - Best choice - Variable-length + (4+n) bytes + Most flexible + Variable unlimited length varchar(n) @@ -513,11 +513,10 @@ CREATE TABLE tablename ( - There is one other fixed-length character type in Postgres. - The name type - only has one purpose and that is for storage of internal catalog - names. - It is not intended for use by the general user. + There is one other fixed-length character type in Postgres. + The name type exists only for + storage of internal catalog names and + is not intended for use by the general user. Its length is currently defined as 32 bytes (31 characters plus terminator) but should be reference using NAMEDATALEN. The length is set at compile time (and is therefore adjustable for -- 2.39.5