With statements does not modify original table untill it is "complete"

PG Doc comments form <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.documentation
Message-ID <[email protected]>
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/queries-with.html
Description:

I think it should be more more visible that data does not change in the
table, untill the with statement is complete. It took some trial-and-error
and fine-reading of the manual before I got this part.

My test code was as following:

create table test(id bigint);
insert into test(id) VALUES(1), (2), (3), (4);
with del as                           
(delete from test where id in (1, 2))
select * from test;
 id 
----
  1
  2
  3
  4
(4 rows)
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.