Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

JSON_EXTRACT_ARRAY_ELEMENT_TEXT Function

This function returns a JSON array element in the outermost array of a JSON string, using a zero-based index. The first element in an array is at position 0. If the index is negative or out of bound, JSON_EXTRACT_ARRAY_ELEMENT_TEXT returns empty string.

For more information, see JSON Functions.

Syntax

Copy
json_extract_array_element_text('json string', pos)

Arguments

json_string

A properly formatted JSON string.

pos

An integer representing the index of the array element to be returned, using a zero-based array index.

Return Type

A VARCHAR string representing the JSON array element referenced by pos.

Example

The following example returns array element at position 2:

Copy
select json_extract_array_element_text('[111,112,113]', 2); json_extract_array_element_text ------------------------------- 113