Doc: mention limitation of the number of resultset columns

david-rowley · david-rowley · commit bbb6489042a8 · 2022-06-01T12:44:45.000+12:00
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
diff --git 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>
