diff options
| author | David Rowley <drowley@postgresql.org> | 2022-06-01 12:46:18 +1200 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2022-06-01 12:46:18 +1200 |
| commit | f2a0060a9bfb7a6f257a536de5ea2d4f7cedff03 (patch) | |
| tree | 27a21fe565b24208ac5f11f2fae8be53f39c6384 | |
| parent | a694cf4ca496a7db66a61f6ec2a15a9af6493cef (diff) | |
Doc: mention limitation of the number of resultset columns
The PostgreSQL limitations section of the documents mentioned the limit
on the number of columns that can exist in a table. Users might be
surprised to find that there's also a limit on the number of columns that
can exist in a targetlist. Users may experience restrictions which
surprise them if they happened to select a large number of columns from
several tables with many columns. Here we document that there is a
limitation on this and mention what that limit actually is.
Wording proposal by Alvaro Herrera
Reported-by: Vladimir Sitnikov
Author: Dave Crammer
Reviewed-by: Tom Lane
Discussion: https://postgr.es/m/CAB=Je-E18aTYpNqje4mT0iEADpeGLSzwUvo3H9kRRuDdsNo4aQ@mail.gmail.com
Backpatch-through: 12, where the limitations section was added
| -rw-r--r-- | doc/src/sgml/limits.sgml | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/doc/src/sgml/limits.sgml b/doc/src/sgml/limits.sgml index 7713ff71773..d5b2b627ddf 100644 --- a/doc/src/sgml/limits.sgml +++ b/doc/src/sgml/limits.sgml @@ -63,6 +63,12 @@ </row> <row> + <entry>columns in a result set</entry> + <entry>1664</entry> + <entry></entry> + </row> + + <row> <entry>field size</entry> <entry>1 GB</entry> <entry></entry> |