pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: raf <raf@raf.org>
To: pgsql-bugs@lists.postgresql.org
Subject: Re: ERROR: cannot pass more than 100 arguments to a function
Date: Thu, 9 Apr 2020 07:34:13 +1000
Message-ID: <20200408213413.kyohygx2ick2zo7f@raf.org> (raw)
In-Reply-To: <E0EF3255-BC7C-4368-84CD-DF75325901B9@inf-it.com>
References: <E0EF3255-BC7C-4368-84CD-DF75325901B9@inf-it.com>

Ján Máté wrote:

> Hi PostgreSQL,
> 
> I noticed an interesting problem with the default max. number of
> function arguments, especially related to JSON processing.
> 
> I understand that there is a need to limit the max. number of
> arguments for functions, but the current limit (100) is simply too
> restrictive for tables with large number of columns (according to my
> findings it is >250 depending on column types).
> 
> A simple example:
> 
> - I have a table with 70 columns
> 
> - I want to select the most simple JSON output from that table:
> 
> SELECT
> json_build_object(
> 'a', "col1",
> 'b', "col2",
> 'c', "col2",
> ...
> )
> FROM "schema"."table";
> 
> - with the 100 arguments limit I can select only 50 columns - 50 x
> (jsonKeyName + ColumnName) = 100 arguments
> 
> - if the limit of columns in the table is >250, why I cannot select at
> least 250 columns using the built-in json_build_object(...) function?
> 
> 
> Please someone consider to increase the default limit from 100 to at
> least 500 (2x max. number of columns) for json_build_object(...) and
> other similar JSON functions.
> 
> Kind regards,
> JM

If you need that many arguments to represent the columns in a table,
then you can use a single argument whose type is the table. e.g.

  create table t (...);
  create or replace function f(a t) ...;
  select * from f(row(...));

If you need that many arguments, and they don't represent a table,
you can create an empty table just for its type definition and then
do the above.

cheers,
raf






view thread (3+ messages)

Message-ID: <20200408213413.kyohygx2ick2zo7f@raf.org>
Permalink:  ../20200408213413.kyohygx2ick2zo7f@raf.org/
Also on:    postgresql.org/message-id/20200408213413.kyohygx2ick2zo7f@raf.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: raf@raf.org
  Subject: Re: ERROR: cannot pass more than 100 arguments to a function
  In-Reply-To: <20200408213413.kyohygx2ick2zo7f@raf.org>
  References: <E0EF3255-BC7C-4368-84CD-DF75325901B9@inf-it.com> <20200408213413.kyohygx2ick2zo7f@raf.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox