Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpaGn-00073p-Hp for pgsql-docs@arkaria.postgresql.org; Tue, 23 Nov 2021 18:11:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mpaGG-0005Ei-FW for pgsql-docs@arkaria.postgresql.org; Tue, 23 Nov 2021 18:11:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpaGG-0005BC-5h for pgsql-docs@lists.postgresql.org; Tue, 23 Nov 2021 18:11:20 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpaGD-00055A-O2 for pgsql-docs@postgresql.org; Tue, 23 Nov 2021 18:11:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=+kGHwBJM5uiseKATb6nvjBZBCb5qAZBSe/6RmBajLD0=; b=yhfLthrfI5J0C1suyo4vtNiDC8 EWNlnYDEERiK0rAFuXqEpGhjCu9NE7HG2kUdLxCQIapD884GEmvWHEpRGlJGAwt9vEXRTRhHob1qa GGWdDl24v7SJj9kz/fO+rzSI0dLuXXYWGLgZxzB8rIOVo8jqz9QnWcPC/Uap56HFetu23hHlbNOHX 0QGANEMNkaZeY88HiWgYfL1l4bwjlOEKHc9BNrTmOPza9svnP4o8U7+AvYdL38eySCI5IKx3hjQlL Fd4yj0ZW1WP7Pk2VtWKomMGtsoSznaY3fiizMBmBJHrMsljGnbYJYwgiDNh3e20V4kINQYyv0lIpT TlzrmlcA==; Received: from [52.119.84.106] (helo=[192.168.88.250]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mpaG9-0004z8-3P; Tue, 23 Nov 2021 18:11:15 +0000 Message-ID: <0db5b15e-ce75-f572-2686-b6209084c8e6@postgresql.org> Date: Tue, 23 Nov 2021 13:11:08 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.3.2 Subject: Re: ORDER BY in materialized view example? Content-Language: en-US To: Tom Lane , Peter Eisentraut Cc: Maciek Sakrejda , pgsql-docs@postgresql.org References: <1e9f99f9-9cdb-4bc3-85d9-c017fbc54566@enterprisedb.com> <38996.1637689496@sss.pgh.pa.us> From: "Jonathan S. Katz" In-Reply-To: <38996.1637689496@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------uM0YBfmZLORbvBWuJPjtkNL3" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------uM0YBfmZLORbvBWuJPjtkNL3 Content-Type: multipart/mixed; boundary="------------3hX4HvGYEjrRaStOEE3TnPVO"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane , Peter Eisentraut Cc: Maciek Sakrejda , pgsql-docs@postgresql.org Message-ID: <0db5b15e-ce75-f572-2686-b6209084c8e6@postgresql.org> Subject: Re: ORDER BY in materialized view example? References: <1e9f99f9-9cdb-4bc3-85d9-c017fbc54566@enterprisedb.com> <38996.1637689496@sss.pgh.pa.us> In-Reply-To: <38996.1637689496@sss.pgh.pa.us> --------------3hX4HvGYEjrRaStOEE3TnPVO Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gMTEvMjMvMjEgMTI6NDQgUE0sIFRvbSBMYW5lIHdyb3RlOg0KPiBQZXRlciBFaXNlbnRy YXV0IDxwZXRlci5laXNlbnRyYXV0QGVudGVycHJpc2VkYi5jb20+IHdyaXRlczoNCj4+IE9u IDIzLjExLjIxIDA3OjE4LCBNYWNpZWsgU2FrcmVqZGEgd3JvdGU6DQo+Pj4gQW4gZXhhbXBs ZSBpbiB0aGUgbWF0ZXJpYWxpemVkIHZpZXcgZG9jdW1lbnRhdGlvbiBbMV0gaW5jbHVkZXMg YW4gT1JERVINCj4+PiBCWSBjbGF1c2Ugd2l0aG91dCBhIGNsZWFyIHJlYXNvbi4gRG9lcyBp dCBoZWxwIGJ1aWxkIHRoZSBpbmRleCBtb3JlDQo+Pj4gZWZmaWNpZW50bHk/IEkgc3VwcG9z ZSBpdCdzIGFsc28gc29ydCBvZiBsaWtlIGEgQ0xVU1RFUj8NCj4gDQo+PiBJIGFncmVlIHRo ZSBPUkRFUiBCWSBpcyBub3QgcmVsZXZhbnQgdG8gdGhlIGV4YW1wbGUuICBUaGVyZSBtaWdo dCBiZQ0KPj4gc29tZSBpbXBsZW1lbnRhdGlvbi1kZXBlbmRlbnQgYWR2YW50YWdlIHRvIG9y ZGVyaW5nIGEgbWF0ZXJpYWxpemVkIHZpZXcsDQo+PiBidXQgaWYgdGhlcmUgaXMsIGl0IGlz bid0IGV4cGxhaW5lZCBpbiB0aGUgZXhhbXBsZS4NCj4gDQo+IFllYWguICBJdCB3b3VsZCBy ZXN1bHQgaW4gdGhlIGluaXRpYWwgY29udGVudHMgb2YgdGhlIG1hdHZpZXcgYmVpbmcNCj4g b3JkZXJlZCwgYnV0IEknbSBzdXJlIHdlIGRvbid0IHdpc2ggdG8gZ3VhcmFudGVlIHRoYXQg UkVGUkVTSCB3b3VsZA0KPiBwcmVzZXJ2ZSB0aGF0LiAgSSdtIG9uIGJvYXJkIHdpdGgganVz dCByZW1vdmluZyB0aGUgT1JERVIgQlkgZnJvbQ0KPiB0aGF0IGV4YW1wbGUuDQoNCisxDQoN Cj4gSSdkIHJhdGhlciBzYXkgc29tZXRoaW5nIGxpa2UNCj4gDQo+ICAgICAgSWYgdGhlcmUg aXMgYW4gT1JERVIgQlkgY2xhdXNlIGluIHRoZSBtYXR2aWV3J3MgZGVmaW5pbmcgcXVlcnks DQo+ICAgICAgdGhlIG9yaWdpbmFsIGNvbnRlbnRzIG9mIHRoZSBtYXR2aWV3IHdpbGwgYmUg b3JkZXJlZCB0aGF0IHdheTsNCj4gICAgICBidXQgUkVGUkVTSCBNQVRFUklBTElaRUQgVklF VyBkb2VzIG5vdCBndWFyYW50ZWUgdG8gcHJlc2VydmUNCj4gICAgICB0aGF0IG9yZGVyaW5n Lg0KDQorMS4gSSB0aGluayBJIGdvdCBiaXQgYnkgdGhpcyBpbiB0aGUgcmVhbCB3b3JsZCB5 ZWFycyBiYWNrLiBUaGUgYWJvdmUgDQpjb21tZW50IGlzIHByZXR0eSBjbGVhci4NCg0KVGhh bmtzLA0KDQpKb25hdGhhbg0K --------------3hX4HvGYEjrRaStOEE3TnPVO-- --------------uM0YBfmZLORbvBWuJPjtkNL3 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmGdLrwFAwAAAAAACgkQ8QSccp8cZSfu yxAAqha/eiZRsoDzcVVXbluApGkc1uebgU7PGwG+jnDiD7AfqHcem+BiYAkEhxpKQKsZTeo7DTWv ehDqf2azQQnaFh1sNXy6waL3T2Nv0rSra/E1tO5y9mhzZAyi1Hv9oUOjskHq/007WR6PgPsaNt9o KS50olhtfBANo5hsASrbbD3avzvn5J+IQIPjRMydZbOXMKnyCq2S457XK02N97K1zvNxcJ0zfaMj /J58UwjQK6FObZaw5uHDv2xtgZxoutXImhTQDo+zycoJM3tLI/+V2MEzI9qydpURaq1S/fo0twZ0 Rrm8B1fVU/TaIpQL87Dx6f9OSKpf3AYuSqvanCQ1xKiPYJkDcCGX6Wlt1h/thu0d2gqtminE4Rjg ItJtQQOdP7Tba7iSOdcECPJgm+o/B7T+P+HjuQmPfZNTDPQK7h+R0nS8TihDJ/eButfyggcWWhMt 4BpMlQvu3WpdbbJs4+087i9UAWDRaxCj3GKHvW3DLphbkOP5e1sfpoWd4BUqtCXrbLR/nzClGbLB UXo/fi1DlYln2NIMtJ1O1Uh76WbMJeBkCOfxpNUyfyOyZjeH3kMQVe2XLbhQa5N22JRn7S6x7pPU X8zovmBMv/7KCcCU4KY3TUD1f0c2ohGs4chCMFN8hE2AISSz9YxrWOvijyl/PCKFFEjgWWlqrnzw sw0= =5H2B -----END PGP SIGNATURE----- --------------uM0YBfmZLORbvBWuJPjtkNL3--