struct_extract()

Extract the named entry from the STRUCT.

Reference: DuckDB 2.0.0

Arguments & returns

2 overloads

struct_extract(struct, entry)

Scalar
Overload link structentry Returns
#01 STRUCTVARCHAR ANY

struct_extract(tuple, index)

Scalar
Overload link tupleindex Returns
#02 TUPLEBIGINT ANY

Example

struct_extract example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.