Contains filter to check whether an array field contains an array

[dbauszus-glx]

We should have a filter for layer to check whether an array field contains a set/array of values.

select count(${qID}) from ${table} where ${field} @> ARRAY[${vals}];

[simon-leech]

Agreed - this would be very useful!

array_in and also array_ni would be my preferred naming conventions!

[dbauszus-glx]

I want to avoid confusion with the in / ni [not in] filter which check whether a field value is in or not in a values array.

We should use the official naming convention for the postgres array operator 'contains'.