Functions/Database & utility/element_at
Database & utility Scalar

element_at()

Returns a list containing the value for a given key or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map’s keys else an error is returned

Alias of map_extract()

Arguments & returns

element_at(map, key, …)

Scalar
Overload link mapkey … Varargs Returns
#01 ANYANY ANY ANY

… accepts a variable number of arguments of the type shown.

Example

element_at example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  map_extract(map(['key'], ['val']), 'key');