DuckDB function array_extract — array_extract • dd

array_extract(list = `T[]`, index = BIGINT): Extracts the indexth (1-based) value from the list.
array_extract(string = VARCHAR, index = BIGINT): Extracts a single character from a string using a (1-based) index.
array_extract(struct = STRUCT, entry = VARCHAR): Extracts the named entry from the STRUCT.
array_extract(struct = STRUCT, index = BIGINT): Extracts the entry from an unnamed STRUCT (tuple) using an index (1-based).

Usage

array_extract(list, index)

Arguments

list: T[]
index: BIGINT

Value

T | VARCHAR | ANY

Overloads

array_extract(list = `T[]`, index = BIGINT)
array_extract(string = VARCHAR, index = BIGINT)
array_extract(struct = STRUCT, entry = VARCHAR)
array_extract(struct = STRUCT, index = BIGINT)

SQL examples

array_extract('DuckDB', 2)
array_extract({'i': 3, 'v2': 3, 'v3': 0}, 'i')
array_extract(row(42, 84), 1)
array_extract([4, 5, 6], 3)

See also

Other list: array_length(), concat(), contains(), flatten(), generate_series(), len(), list_aggregate(), list_concat(), list_contains(), list_cosine_distance(), list_cosine_similarity(), list_distance(), list_distinct(), list_extract(), list_filter(), list_grade_up(), list_has_all(), list_has_any(), list_inner_product(), list_intersect(), list_negative_inner_product(), list_position(), list_reduce(), list_resize(), list_reverse_sort(), list_select(), list_slice(), list_sort(), list_transform(), list_unique(), list_value(), list_where(), list_zip(), or–or, range(), repeat(), unpivot_list()

Other string: ascii(), bar(), bin(), bit_length(), chr(), concat(), concat_ws(), contains(), format(), formatReadableDecimalSize(), format_bytes(), from_base64(), greatest(), hash(), hex(), ilike_escape(), instr(), least(), left(), left_grapheme(), len(), length_grapheme(), like_escape(), list_slice(), lower(), lpad(), ltrim(), md5(), md5_number(), nfc_normalize(), not_ilike_escape(), not_like_escape(), or–or, parse_dirname(), parse_dirpath(), parse_filename(), parse_formatted_bytes(), parse_path(), prefix(), printf(), repeat(), replace(), reverse(), right(), right_grapheme(), rpad(), rtrim(), sha1(), sha256(), starts_with(), string_split(), strip_accents(), strlen(), substring(), substring_grapheme(), suffix(), to_base(), to_base64(), translate(), trim(), unbin(), unhex(), unicode(), upper(), url_decode(), url_encode()