Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo
Дата
Msg-id 175578522105.806.9299577429321382358@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/rules-materializedviews.html
Description:

Unless I'm completely mistaken, the second code example on
https://www.postgresql.org/docs/current/rules-materializedviews.html, i.e
this:

CREATE TABLE mymatview AS SELECT * FROM mytab;

Should instead by

CREATE VIEW mymatview AS SELECT * FROM mytab;

(I.e, create a VIEW, not a TABLE).

Could also be debated if the view name should be the same in both examples.
I.e the second example might be even better as below:

CREATE VIEW myview AS SELECT * from mytab;

В списке pgsql-docs по дате отправления: