Functions / Json Functions And Operators

jsonb_array_elements

Expands the top-level JSON array into a set of JSON values.

Reading PG 18current·documented in 14 of 27 versions, 9.4 to 20

Signatures & examples

jsonb_array_elements ( jsonb ) → setof jsonb

Expands the top-level JSON array into a set of JSON values.

select * from json_array_elements('[1,true, [2,false]]') →    value
-----------
 1
 true
 [2,false]

Version history 2

Definition snapshot: b7bd9cda · English manual source