Horton

Doc: improve documentation about ORDER BY in matviews.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: ce43b3dc52c90082981f2f1de5351a95fc21c405
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2021-11-29T17:13:13Z
Releases: 14.2 
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

Files

PathChange+/−
doc/src/sgml/ref/refresh_materialized_view.sgml modified +4 −6
doc/src/sgml/rules.sgml modified +0 −3

Documentation touched

Discussion