Horton

01-drop-materialized-view-order-by.patch

text/x-patch

Download
Filename: 01-drop-materialized-view-order-by.patch
Type: text/x-patch
Part: 0
Message: Re: ORDER BY in materialized view example?

Patch

Format: unified
File+−
doc/src/sgml/rules.sgml 0 3 
commit 45d7ca562daf91f8028335ade2e730bb59d25ba0
Author: Maciek Sakrejda <m.sakrejda@gmail.com>
Date:   Sun Nov 28 16:37:05 2021 -0800

    Drop confusing ORDER BY in materialized view documentation

diff --git a/doc/src/sgml/rules.sgml b/doc/src/sgml/rules.sgml
index 6065b1c2a3..4aa4e00e01 100644
--- a/doc/src/sgml/rules.sgml
+++ b/doc/src/sgml/rules.sgml
@@ -961,9 +961,6 @@ CREATE MATERIALIZED VIEW sales_summary AS
     FROM invoice
     WHERE invoice_date &lt; CURRENT_DATE
     GROUP BY
-      seller_no,
-      invoice_date
-    ORDER BY
       seller_no,
       invoice_date;