postgresql - Compare arrays for equality, ignoring order of elements

Question

I have a table with 4 array columns.. the results are like:

ids       signed_ids   new_ids   new_ids_signed
{1,2,3} | {2,1,3}    | {4,5,6} | {6,5,4}

Anyway to compare ids and signed_ids so that they come out equal, by ignoring the order of the elements?

Answer 1

You can use contained by operator:

(array1 <@ array2 and array1 @> array2)