]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: improve documentation about ORDER BY in matviews.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 29 Nov 2021 17:13:13 +0000 (12:13 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 29 Nov 2021 17:13:13 +0000 (12:13 -0500)
commitce43b3dc52c90082981f2f1de5351a95fc21c405
treef9582fe9bc6c85fef9db1d3ce3e360964ae4d729
parent1b1e4bfe7da770ad159c0f4291925a3597a65dbc
Doc: improve documentation about ORDER BY in matviews.

Remove the confusing use of ORDER BY in an example materialized
view.  It adds nothing to the example, but might encourage
people to follow bad practice.  Clarify REFRESH MATERIALIZED
VIEW's note about whether view ordering is retained (it isn't).

Maciek Sakrejda

Discussion: https://postgr.es/m/CAOtHd0D-OvrUU0C=4hX28p4BaSE1XL78BAQ0VcDaLLt8tdUzsg@mail.gmail.com
doc/src/sgml/ref/refresh_materialized_view.sgml
doc/src/sgml/rules.sgml