switch()

Creates a switch statement similar to CASE WHEN/THEN

Reference: DuckDB 2.0.0

Arguments & returns

4 overloads

switch(map)

Scalar
Overload link map Returns
#01 MAP(K, V) V

switch(key, map)

Scalar
Overload link keymap Returns
#02 KMAP(K, V) V

switch(map, value)

Scalar
Overload link mapvalue Returns
#03 MAP(K, V)V V

switch(key, map, value)

Scalar
Overload link keymapvalue Returns
#04 KMAP(K, V)V V

Catalog examples

SELECT switch(x, map({1 : 1}, default);