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]
An extension to Denis' answer that returns the difference, regardless of which array was entered first. It's not the most concise query, maybe someone has a tidier way.
select array_cat(
(select array(select unnest(a.b::int[]) except select unnest(a.c::int[]))),
(select array(select unnest(a.c::int[]) except select unnest(a.b::int[]))))
from (select '{1,2}'::int[] b,'{1,3}'::int[] c) as a;
Returns:
{2,3}