pgsql: Doc: improve documentation about ORDER BY in matviews.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: improve documentation about ORDER BY in matviews.
Date: 2021-11-29 17:13:33
Message-ID: E1mrkDd-000794-Pg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/3f43dcc1c6868aac1f22861e6363577a431772cf

Modified Files
--------------
doc/src/sgml/ref/refresh_materialized_view.sgml | 10 ++++------
doc/src/sgml/rules.sgml | 3 ---
2 files changed, 4 insertions(+), 9 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Geoghegan 2021-11-29 17:59:46 pgsql: vacuumlazy.c: Rename dead_tuples to dead_items.
Previous Message Peter Geoghegan 2021-11-29 16:40:31 Re: pgsql: Update high level vacuumlazy.c comments.