postgres.git / summary / log / commit / refs

commit    514f0ae4f40f322b1a10bd774abd4b4d01c97a99
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Mon Nov 29 17:13:13 2021 +0000
First released in: 15.0, 10.20, 11.15, 12.10, 13.6, 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


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

diff --git a/doc/src/sgml/ref/refresh_materialized_view.sgml b/doc/src/sgml/ref/refresh_materialized_view.sgml
index 82d1628e802..86bf5c462b6 100644
--- a/doc/src/sgml/ref/refresh_materialized_view.sgml
+++ b/doc/src/sgml/ref/refresh_materialized_view.sgml
@@ -93,12 +93,10 @@ REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] <replaceable class="PARAMETER">name</
   <title>Notes</title>
 
   <para>
-   While the default index for future
-   <xref linkend="SQL-CLUSTER">
-   operations is retained, <command>REFRESH MATERIALIZED VIEW</> does not
-   order the generated rows based on this property. If you want the data
-   to be ordered upon generation, you must use an <literal>ORDER BY</>
-   clause in the backing query.
+   If there is an <literal>ORDER BY</literal> clause in the materialized
+   view's defining query, the original contents of the materialized view
+   will be ordered that way; but <command>REFRESH MATERIALIZED
+   VIEW</command> does not guarantee to preserve that ordering.
   </para>
  </refsect1>
 
diff --git a/doc/src/sgml/rules.sgml b/doc/src/sgml/rules.sgml
index 5c30e361d42..8da83715681 100644
--- a/doc/src/sgml/rules.sgml
+++ b/doc/src/sgml/rules.sgml
@@ -956,9 +956,6 @@ CREATE MATERIALIZED VIEW sales_summary AS
     FROM invoice
     WHERE invoice_date < CURRENT_DATE
     GROUP BY
-      seller_no,
-      invoice_date
-    ORDER BY
       seller_no,
       invoice_date;
 


[parent: 72cf39d51ade]