Doc: improve documentation about ORDER BY in matviews.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 29 Nov 2021 17:13:12 +0000 (12:13 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 29 Nov 2021 17:13:12 +0000 (12:13 -0500)
commit4f33af23e7e3ac30b3cb9480981c3accf401ef01
tree886c1cdf3c88645be25642e534e8124d2fdc72dc
parente04a8059a74c125a8af94acdcb7b15b92188470a
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