FUNCTIONS / JSON FUNCTIONS AND OPERATORS

json_array_elements

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

Signatures & examples

json_array_elements ( json ) → setof json

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 3

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source