Re: PostgreSQL Limits: maximum number of columns in SELECT result

On Tue, 31 May 2022 at 09:56, Amul Sul <sulamul@gmail.com> wrote:

On Tue, May 31, 2022 at 12:46 PM Vladimir Sitnikov
<sitnikov.vladimir@gmail.com> wrote:
>
> Hi,
>
> Today I hit "ERROR: target lists can have at most 1664 entries", and I was surprised the limit was not documented.
>
> I suggest that the limit of "1664 columns per tuple" (or whatever is the right term) should be added
> to the list at https://www.postgresql.org/docs/current/limits.html e.g. after "columns per table".
>

Rather, I think the "columns per table" limit needs to be updated to 1664.

Actually that is correct. Columns per table is MaxHeapAttributeNumber which is 1600.

MaxTupleAttributeNumber  is 1664  and is the limit of user columns in a tuple.

Dave