Discussion on: Subtract Arrays in PostgreSQL

[Chase Pursley]

Nice! If you want to get fancy, you can create an operator like this:

CREATE OPERATOR - (
  LEFTARG = anyarray,
  RIGHTARG = anyarray,
  PROCEDURE = array_subtract
);

And use like this:

select ('{2,3,4}'::int[] - '{1,2,3,4,5}'::int[])'