How can I pick only the non matching elements between two arrays.
Example:
base_array [12,3,5,7,8] temp_array [3,7,8]
So here I want to compare both the arrays and remove the matching elements from the base array.
Now base_array should be like [12,5]
[12,5]
I'd approach this with the array operator.
select array(select unnest(:arr1) except select unnest(:arr2));
If :arr1 and :arr2 don't intersect, using array_agg() leads to a null.
2.1m questions
2.1m answers
60 comments
56.9k users