Functions/Database & utility/switch
Database & utility Scalar

switch()

Creates a switch statement similar to CASE WHEN/THEN

Arguments & returns

4 overloads

switch(key)

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

switch(key, map)

Scalar
Overload link keymap Returns
#02 KMAP(K, V) V
#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);