postgres.git / summary / log / commit / refs

commit    f2a0060a9bfb7a6f257a536de5ea2d4f7cedff03
Author:   David Rowley <drowley@postgresql.org>
Date:     Wed Jun 01 00:46:18 2022 +0000

    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


 doc/src/sgml/limits.sgml | 6 ++++++
 1 file changed, 6 insertions(+)

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
@@ -62,6 +62,12 @@
      below</entry>
     </row>
 
+    <row>
+     <entry>columns in a result set</entry>
+     <entry>1664</entry>
+     <entry></entry>
+    </row>
+
     <row>
      <entry>field size</entry>
      <entry>1 GB</entry>


[parent: a694cf4ca496]