如何比较两个数组并在postgres中仅选择非匹配元素

SELECT array_agg(t1.element) AS non_matching_elements
FROM (
  SELECT unnest(array1) AS element
  FROM your_table
) t1
LEFT JOIN (
  SELECT unnest(array2) AS element
  FROM your_table
) t2 ON t1.element = t2.element
WHERE t2.element IS NULL;

SELECT array_agg(element) AS non_matching_elements
FROM (
  SELECT unnest(array1) AS element
  FROM your_table
) t
WHERE t.element NOT IN (
  SELECT unnest(array2)
  FROM your_table
);