Maps & structs Scalar

struct_extract()

Extract the named entry from the STRUCT.

Arguments & returns

2 overloads

Scalar

Overload link	`struct`	`'entry'`	Returns
#01	`STRUCT`	`BIGINT`	`ANY`
#02	`STRUCT`	`VARCHAR`	`ANY`

SELECT struct_extract({'i': 3, 'v2': 3, 'v3': 0}, 'i');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.