Lists & arrays Scalar

array_distinct()

Removes all duplicates and NULL values from a list. Does not preserve the original order.

Arguments & returns

Scalar

Overload link	`list`	Returns
#01	`T[]`	`T[]`

SELECT array_distinct([1, 1, NULL, -3, 1, 5]);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.