Check if a multi choice field contains ALL given values…and possibly additional values not given in the query.
SELECT materials FROM Buildings WHERE materials @> ARRAY['brick', 'glass'] -- returns rows where brick *and* glass were selected