json_array_get(json_array text, index int4)
Advertisements
Let us now check the json_array_get(json_array text, index int4) function with the following query.
Query
default> select json_array_get('[10, 20, 30]', 2) as array;
Result
The above query will generate the following result.
array ------------------------------- 30
The query returns the element at the specified index into the JSON array. Here, 2 index has 20 array element.
apache_tajo_json_functions.htm
Advertisements