postgres.git / summary / log / commit / refs

commit    3563d5f23ef4e8826e82026cc976e9ad25c9af85
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Wed Aug 31 23:43:06 2022 +0000
First released in: 16.0, 10.23, 11.18, 12.13, 13.9, 14.6, 15.0

    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 cd3678f732b..a5bb91fed9e 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1117,6 +1117,8 @@ SELECT '52093.89'::money::numeric::float8;
     <type>char(<replaceable>n</replaceable>)</type> are aliases for <type>character
     varying(<replaceable>n</replaceable>)</type> and
     <type>character(<replaceable>n</replaceable>)</type>, respectively.
+    If specified, the length must be greater than zero and cannot exceed
+    10485760.
     <type>character</type> without length specifier is equivalent to
     <type>character(1)</type>. If <type>character varying</type> is used
     without length specifier, the type accepts strings of any size. The


[parent: 17f073f17c3b]