Maps & structs Scalar

map_concat()

Returns a map created from merging the input maps, on key collision the value is taken from the last map with that key

Arguments & returns

Scalar

Overload link	… Varargs	Returns
#01	`ANY`	`LIST`

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

SELECT map_concat(map([1, 2], ['a', 'b']), map([2, 3], ['c', 'd']));

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT id, MAP_INSERT(attrs, 'new_key', 'new_value') AS attrs_with_insert FROM demo_maps

In DuckDB

SELECT id, MAP_CONCAT(attrs, MAP {'new_key': 'new_value'}) AS attrs_with_insert FROM demo_maps