]> 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)
commita7359913a1c22e8c04f37140b9d983919baf10b2
tree2e8a4ca54361ad207762ad29075b9321d8a219a2
parentf76fd05bae047103cb36ef5fb82137c8995142c1
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