FunctionsJSON

json_array_element_text

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

json_array_element_text(…) → String

Kind · scalar

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

Part of the JSON family.

json_array_element

Returns the JSON element at the requested array index. Negative indexes count backward from the end.

json_array_elements

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