Hi,
# SELECT '[[5,2],"a",[8,[3,2],6]]'::jsonb;
jsonb
-------------------------------
[[5, 2], "a", [8, [3, 2], 6]]
(1 row)
unnest(array[[3,2],"a",[1,4]]) is not accepted currently.
Would the enhanced unnest accept the above array ?
Cheers
On Sun, Feb 7, 2021, at 17:27, Tom Lane wrote:
>> Having thought about this some more,
>> the function name should of course be jsonb_unnest(),
>> similar to how unnest() works for normal arrays:
>
>Why not just unnest(), then?
>
>regards, tom lane
Ahh, of course! I totally forgot about function overloading when thinking about this.
+1
/Joel