diff options
-rw-r--r-- | doc/src/sgml/ref/refresh_materialized_view.sgml | 10 | ||||
-rw-r--r-- | 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 8ae62671ada..675d6090f3c 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</command> 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</literal> - 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 f9df9de8ae1..5b4fc5b12be 100644 --- a/doc/src/sgml/rules.sgml +++ b/doc/src/sgml/rules.sgml @@ -957,9 +957,6 @@ CREATE MATERIALIZED VIEW sales_summary AS WHERE invoice_date < CURRENT_DATE GROUP BY seller_no, - invoice_date - ORDER BY - seller_no, invoice_date; CREATE UNIQUE INDEX sales_summary_seller |