JSON Functions
Overview
JSON Functions
Overview
To help you query JSON data, Oxla provides some functions that will be used to operate and manipulate the JSON data. The functions are as follows:
| Functions | Description |
|---|---|
| JSON_EXTRACT_PATH() | It extracts JSON sub-object at the specified path. |
| JSON_EXTRACT_PATH_TEXT() | It returns text referenced by a series of path elements in a JSON string or JSON body. |
| JSON_ARRAY_LENGTH() | It returns the number of elements in the outer array of a JSON string or JSON body. |
| JSON_ARRAY_EXTRACT() | It returns the JSON array as a set of JSON values. |
Operators are used to specify conditions when using JSON functions. Oxla also supports JSON operators as listed below:
| Operators | Description | Example |
|---|---|---|
| -> | It gets & returns the element of the JSON array. | '[{"a":"cab"},{"b":"bac"},{"c":"abc"}]'::json -> 2 |
| -> | It gets & returns the JSON object field. | '{"a": {"b":"abc"}}'::json -> 'a' |
| ->> | It gets & returns the element of the JSON array as text. | '[11,22,33]'::json ->> 2 |
| ->> | It gets & returns the JSON object field as text. | '{"a":13,"b":33}'::json ->> 'b' |