diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-08-31 19:43:06 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-08-31 19:43:06 -0400 |
| commit | 62c49fca1330954a678d1d74e2a7883eb950fcff (patch) | |
| tree | 1b5d5116e046a5f505b2d6996e74c6c4b1df9ace | |
| parent | 9bdad1b5153e5d6b77a8f9c6e32286d6bafcd76d (diff) | |
| download | postgresql-62c49fca1330954a678d1d74e2a7883eb950fcff.tar.gz postgresql-62c49fca1330954a678d1d74e2a7883eb950fcff.zip | |
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
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 2 |
1 files changed, 2 insertions, 0 deletions
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; <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 |