From the source
We're shipping three improvements: filters that combine across multiple columns, more filter operators, and column selection so a subscription returns only the fields you ask for.
All three are available now.
Postgres Changes lets you subscribe to inserts, updates, and deletes on a Postgres table and receive them over a WebSocket as they happen.
Filter on more than one column # A support inbox is a good example.
You want a live view of the tickets that are open and assigned to your team, and nothing else.
Until now a filter could only look at one column, so you could match on status or on team, but not both at once.
The workaround was to subscribe to every open ticket in the table and drop the ones for other teams once they reached your app.
Filters now compose.
Separate them with a comma and every condition has to match: More filter operators # Filters also support like and ilike for patterns, is for null and boolean checks, match and imatch for POSIX regular expressions, and isdistinct for NULL-safe inequality.
Prefix any of them with not. to invert it: If you'd rather build filters in code than assemble strings, there's a builder: …
