3 ms·
Fwiw this approach doesn't work for something like: SELECT * FROM Products WHERE price > 5; If a new product comes in with price 20 you won't know to add it t
by rockwotj 6y ago
Fwiw this approach doesn't work for something like:
SELECT * FROM Products WHERE price > 5;
If a new product comes in with price 20 you won't know to add it to your result set and send it to the clients.
- touisteur 6y agoEven from a view? Materialized or not?
- rockwotj 6y agoOnly if you keep the whole table in memory or re-read every row that is written
- kissgyorgy 6y agoYou would send the new id in NOTIFY when something inserts the new product.
- rockwotj 6y agoYou'd have to send the full row otherwise you wouldn't know if it matches the query or not