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
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