On 2020-11-15 04:55, David G. Johnston wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-createtableas.html
Description:
Hi.
I think you should include an example on how to create a table from a query
that uses a CTE in the query.
[shrug]
The obvious attempt to specify:
create table cte_tbl as
WITH cte (val) AS (select 1)
SELECT * FROM cte;
works so I'm not really sure that such an example adds valuable insight.
That is probably a totaly worthless example for a experienced user.
The only insight would be for a new user that "oh, I can do it like that".