Re: Example of json_array_elements

> On 12 Nov 2021, at 13:18, PG Doc comments form <noreply(at)postgresql(dot)org> wrote:

> Maybe this example for json_array_elements is wrong?

No, the example works as intended and yields the output in the documentation:

postgres=# select * from json_array_elements('[1,true, [2,false]]');
value
-----------
1
true
[2,false]
(3 rows)

Your proposal is also syntactically correct, but it's not what the author
intended when writing the example:

postgres=# select * from json_array_elements('[[1,true], [2,false]]');
value
-----------
[1,true]
[2,false]
(2 rows)

--
Daniel Gustafsson https://vmware.com/