FunctionsJSON

json_array_elements

Returns a normalized JSON array containing the top-level elements from each input JSON array value.

json_array_elements(…) → JSON

Kind · scalar

Returns a normalized JSON array containing the top-level elements from each input JSON array value.

Part of the JSON family.

json_array_element_text

Returns the selected JSON array element converted to textual form, unquoting JSON strings.

json_array_elements_text

Returns each top-level JSON array element converted to text and packed into a JSON string array.