[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-hackers
Subject:    Re: PostgreSQL Limits: maximum number of columns in SELECT result
From:       Dave Cramer <davecramer () postgres ! rocks>
Date:       2022-05-31 19:07:56
Message-ID: CADK3HHKVg=pUmqkJid5dMuN8Pj6mXyTEg7v9XSzUyUktTPXZmw () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


On Tue, 31 May 2022 at 14:51, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> > I think it's reasonable to have two adjacent rows in the table for these
> > two closely related things, but rather than "columns per tuple" I would
> > label the second one "columns in a result set".  This is easy enough to
> > understand and to differentiate from the other limit.
>
> OK, with that wording it's probably clear enough.
>
>                         regards, tom lane
>
> Reworded patch attached

[Attachment #5 (text/html)]

<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Tue, 31 May 2022 at 14:51, Tom Lane &lt;<a \
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">Alvaro Herrera &lt;<a \
href="mailto:alvherre@alvh.no-ip.org" target="_blank">alvherre@alvh.no-ip.org</a>&gt; \
writes:<br> &gt; I think it&#39;s reasonable to have two adjacent rows in the table \
for these<br> &gt; two closely related things, but rather than &quot;columns per \
tuple&quot; I would<br> &gt; label the second one &quot;columns in a result \
set&quot;.   This is easy enough to<br> &gt; understand and to differentiate from the \
other limit.<br> <br>
OK, with that wording it&#39;s probably clear enough.<br>
<br>
                                    regards, tom lane<br>
<br></blockquote><div>Reworded patch attached</div><div>  </div></div></div>

--0000000000008a866505e0537e57--


["columns_per_tuple.patch" (application/octet-stream)]

diff --git a/doc/src/sgml/limits.sgml b/doc/src/sgml/limits.sgml
index 7713ff7177..98bcd80c31 100644
--- a/doc/src/sgml/limits.sgml
+++ b/doc/src/sgml/limits.sgml
@@ -62,6 +62,12 @@
      below</entry>
     </row>
 
+    <row>
+     <entry>user columns in a resultset</entry>
+     <entry>1664</entry>
+     <entry>Limit of user columns in a resultset</entry>
+    </row>
+
     <row>
      <entry>field size</entry>
      <entry>1 GB</entry>


[prev in list] [next in list] [prev in thread] [next in thread]