Re: json_build_object, numeric types, and function limits on 100 arguments

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: json_build_object, numeric types, and function limits on 100 arguments
Date: 2021-01-26 21:42:19
Message-ID: 2338155.1611697339@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> Yeah, thanks, I thought about that: concatenating a few different objects
> to make a bigger object. Seemed silly, but if there's not a cleaner
> solution, it does work.

A more SQL-ish way to deal with this might be to use jsonb_agg()
or jsonb_object_agg().

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2021-01-27 06:39:35 Re: json_build_object, numeric types, and function limits on 100 arguments
Previous Message Wells Oliver 2021-01-26 19:10:32 Re: json_build_object, numeric types, and function limits on 100 arguments