electric
electric copied to clipboard
expand WHERE filter to support "array contains" operator
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'];