FunctionsJSON

json_array_element

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

json_array_element(…) → JSON

Kind · scalar

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

Part of the JSON family.

json_all_paths_with_types

Parses each JSON document and returns a JSON array of path:type entries for all observed nested values.

json_array_element_text

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