From 62c49fca1330954a678d1d74e2a7883eb950fcff Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Wed, 31 Aug 2022 19:43:06 -0400
Subject: doc: document the maximum char/varchar length value
Reported-by: Japin Li
Discussion: https://postgr.es/m/MEYP282MB1669B13E98AE531617CB1386B6979@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
Backpatch-through: 10
---
doc/src/sgml/datatype.sgml | 2 ++
1 file changed, 2 insertions(+)
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 4cc9e592708..0258b192e0e 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1217,6 +1217,8 @@ SELECT '52093.89'::money::numeric::float8;
char(n) are aliases for character
varying(n) and
character(n), respectively.
+ If specified, the length must be greater than zero and cannot exceed
+ 10485760.
character without length specifier is equivalent to
character(1). If character varying is used
without length specifier, the type accepts strings of any size. The
--
cgit v1.2.3