On Fri, Aug 22, 2025, at 23:40, David G. Johnston wrote:
Unless I'm completely mistaken, the second code example on
this:
CREATE TABLE mymatview AS SELECT * FROM mytab;
Should instead by
CREATE VIEW mymatview AS SELECT * FROM mytab;
No, the example's intent is to compare a true "materialized view" with a table that is simply populated from a query. The comment "the materialized view cannot subsequently be directly updated" only makes sense as a counterpoint to a physical table.
David J.
Right, I stand corrected, and realize I don't know enough about standard view.
Maybe its the naming of the example *table* with the suffix *view* that completely mess up my brain, but I guess given the intent that's how it should be.
Thanks,
Erik
