I assume that field1 is an array, as opposed to just a simple value variable. A simple value variable would be tested with something like: field1 IN ( subquery) . The @< tests that every value in the array field1 is also in the subquery. The subquery might contain other values, but it will contain _all_ values in field1.