risingwave_expr_impl::scalar::array_distinct

Function array_distinct

Source 
pub fn array_distinct(list: ListRef<'_>) -> ListValue
Expand description

Returns a new array removing all the duplicates from the input array

array_distinct (array anyarray) → array

Examples:

query T
select array_distinct(array[NULL]);
----
{NULL}

query T
select array_distinct(array[1,2,1,1]);
----
{1,2}

query T
select array_distinct(array[1,2,1,NULL]);
----
{1,2,NULL}

query T
select array_distinct(null::int[]);
----
NULL

query error polymorphic type
select array_distinct(null);