electric icon indicating copy to clipboard operation
electric copied to clipboard

expand WHERE filter to support "array contains" operator

Open ericallam opened this issue 1 year ago • 0 comments

We want to be able to subscribe to changes on a table that has an array of strings column (think a tags column) and we want to be able to filter for only changes where tags includes a specific string, using the @> operator. The SQL would be something like this:

SELECT *
FROM runs
WHERE tags @> ARRAY['org:1234'];

ericallam avatar Sep 30 '24 13:09 ericallam