Re: jsonb_array_elements_recursive() - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: jsonb_array_elements_recursive()
Date
Msg-id CAKFQuwaKZSUiQj1pGiSd5g3L7a-wcEmMkR_nimXebFJcM_3SnQ@mail.gmail.com
Whole thread Raw
In response to Re: jsonb_array_elements_recursive()  (Zhihong Yu <zyu@yugabyte.com>)
List pgsql-hackers
On Sunday, February 7, 2021, Zhihong Yu <zyu@yugabyte.com> wrote:
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 ?

Its not possible to even create that sql array so whether the unnest function could do something useful with it is immaterial.

David J.

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: jsonb_array_elements_recursive()
Next
From: "Joel Jacobson"
Date:
Subject: Re: jsonb_array_elements_recursive()