json_array_get(json_array text, index int4)

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.