The JSON functions are listed in the following table −
S.No. | Function & Description |
---|---|
1 | json_extract_path_text(js on text, json_path text)
Extracts JSON string from a JSON string based on json path specified. |
2 | json_array_get(json_array text, index int4)
Returns the element at the specified index into the JSON array. |
3 | json_array_contains(json_ array text, value any)
Determine if the given value exists in the JSON array. |
4 | json_array_length(json_ar ray text)
Returns the length of json array. |