Re: Wrong statement on the materialized views page

Поиск
Список
Период
Сортировка
От Erik Wienhold
Тема Re: Wrong statement on the materialized views page
Дата
Msg-id 1300044510.104825.1692607022369@office.mailbox.org
обсуждение исходный текст
Ответ на Wrong statement on the materialized views page  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: Wrong statement on the materialized views page  (Mark Meeus <mark.meeus@gmail.com>)
Список pgsql-docs
> On 21/08/2023 09:02 CEST PG Doc comments form <noreply@postgresql.org> wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/15/rules-materializedviews.html
> Description:
>
> There might be an issue on this page:
> https://www.postgresql.org/docs/current/rules-materializedviews.html
>
> I think the statement 
> CREATE TABLE mymatview AS SELECT * FROM mytab;
> should actuall be
> CREATE VIEW mymatview AS SELECT * FROM mytab;

No, CREATE TABLE is correct in this case because that section is about the
persistence of matview results like a table.

--
Erik



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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Wrong statement on the materialized views page
Следующее
От: Mark Meeus
Дата:
Сообщение: Re: Wrong statement on the materialized views page