Postgres Pro
Downloads
Home   >   mailing lists

Re: json_build_object, numeric types, and function limits on 100 arguments - Mailing list pgsql-admin

From Tom Lane
Subject Re: json_build_object, numeric types, and function limits on 100 arguments
Date
Msg-id 2338155.1611697339@sss.pgh.pa.us
Whole thread Raw
In response to Re: json_build_object, numeric types, and function limits on 100 arguments  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: json_build_object, numeric types, and function limits on 100 arguments
List pgsql-admin
Tree view 
Wells Oliver <wells.oliver@gmail.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

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: json_build_object, numeric types, and function limits on 100 arguments
Next
From: Wells Oliver
Date:
Subject: Re: json_build_object, numeric types, and function limits on 100 arguments