Lists & arrays
Macro
list_append()
Arguments & returns
list_append(l, e)
Macro
| Overload link | l | e |
Returns |
|---|---|---|---|
| #01 | unknown | unknown |
unknown |
Definition
list_concat(l, list_value(e))In other engines
Used in larger rewrites 1
These examples use list_append as one part of a larger SQL translation.
Snowflakearray_distinct()
SELECT ARRAY_DISTINCT(col)
In DuckDBSELECT CASE WHEN ARRAY_LENGTH(col) <> LIST_COUNT(col) THEN LIST_APPEND(LIST_DISTINCT(LIST_FILTER(col, _u -> NOT _u IS NULL)), NULL) ELSE LIST_DISTINCT(col) END