PostgreSQL - Views and Materialized Views
Given the materialized view
mv_products created as CREATE MATERIALIZED VIEW mv_products AS SELECT id, price FROM products;, what will be the result of this query immediately after inserting a new product into products but before refreshing mv_products?
SELECT * FROM mv_products WHERE id = 101;
