Database & utility
Scalar
switch()
Creates a switch statement similar to CASE WHEN/THEN
Reference: DuckDB 2.0.0
Arguments & returns
4 overloadsswitch(map)
Scalar
| Overload link | map |
Returns |
|---|---|---|
| #01 | MAP(K, V) |
V |
switch(key, map)
Scalar
| Overload link | key | map |
Returns |
|---|---|---|---|
| #02 | K | MAP(K, V) |
V |
switch(map, value)
Scalar
| Overload link | map | value |
Returns |
|---|---|---|---|
| #03 | MAP(K, V) | V |
V |
switch(key, map, value)
Scalar
| Overload link | key | map | value |
Returns |
|---|---|---|---|---|
| #04 | K | MAP(K, V) | V |
V |
Catalog examples
SELECT switch(x, map({1 : 1}, default);