Maps & structs Scalar

union_extract()

Extract the value with the named tags from the union. NULL if the tag is not currently selected

Arguments & returns

Scalar

Overload link	`union`	`tag`	Returns
#01	`UNION`	`VARCHAR`	`ANY`

SELECT union_extract(union_value(k := 42), 'k') AS value;

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT
  union_extract(s, 'k');