Hi. I am trying to build a Large JSON Object, and running into issues with
the function limit on 100 arguments. I know I can use ARRAY[] to get around
this, but I can't mix text and numeric types, which I need to do to have a
nicely usable JSON object.
I know I can do this: json_build_object('somekey', 1.0, 'someotherkey',
2.0) but cannot put more than 100.
What I can't do is json_build_object(array['somekey', 1.0, 'someotherkey',
2.0]); (json_object() with the same error): invalid input syntax for type
numeric: "somekey"
What I can do but don't want to do is json_object(array['somekey', '2.0',
'someotherkey', '2.0']) because you have a poorly typed JSON object that's
less helpful downstream.
Any options for me?
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>