]> 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)
commit2f908e1a3b9c07e43d3ad9ebe6633fae1ed355e3
tree913c72cf0398b2de5f974cdbc0115b5677dddf4c
parent733f2be094aabf5468a40e5e0137a1d3a071d81f
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