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 1nROQd-0004Cp-BY for pgsql-committers@arkaria.postgresql.org; Tue, 08 Mar 2022 01:14:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nROQc-0003Fv-6J for pgsql-committers@arkaria.postgresql.org; Tue, 08 Mar 2022 01:14:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nROQb-0003Do-VD for pgsql-committers@lists.postgresql.org; Tue, 08 Mar 2022 01:14:17 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nROQZ-0002as-Lq for pgsql-committers@lists.postgresql.org; Tue, 08 Mar 2022 01:14:16 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nROQZ-000850-5k for pgsql-committers@lists.postgresql.org; Tue, 08 Mar 2022 01:14:15 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nROQY-001PO0-2s for pgsql-committers@lists.postgresql.org; Tue, 08 Mar 2022 01:14:14 +0000 Content-Type: multipart/mixed; boundary="===============0585477220356278880==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Simplify SRFs using materialize mode in contrib/ modules X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 08 Mar 2022 01:14:14 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0585477220356278880== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2ltcGxpZnkgU1JGcyB1c2luZyBtYXRlcmlhbGl6ZSBtb2RlIGluIGNvbnRyaWIvIG1vZHVsZXMK CjllOTg1ODMgaW50cm9kdWNlZCBhIGhlbHBlciB0byBjZW50cmFsaXplIGJ1aWxkaW5nIHRoZWly IG5lZWRlZCBzdGF0ZQoodHVwbGVzdG9yZSwgdHVwbGUgZGVzY3JpcHRvcnMsIGV0Yy4pLCBjaGVj a2luZyBmb3IgYW55IGVycm9ycy4gIFRoaXMKY29tbWl0IHVwZGF0ZXMgYWxsIHBsYWNlcyBvZiBj b250cmliLyB0aGF0IGNhbiBiZSBzd2l0Y2hlZCB0byB1c2UKU2V0U2luZ2xlRnVuY0NhbGwoKSBh cyBhIGRyb3AtaW4gcmVwbGFjZW1lbnQsIHJlc3VsdGluZyBpbiB0aGUgcmVtb3ZhbApvZiBhIGxv dCBvZiBib2lsZXJwbGF0ZSBjb2RlIGluIGFsbCB0aGUgbW9kdWxlcyB1cGRhdGVkIGJ5IHRoaXMg Y29tbWl0LgoKUGVyIGFuYWx5c2lzLCBzb21lIHBsYWNlcyByZW1haW4gYXMgdGhleSBhcmU6Ci0g cGdfbG9nZGlyX2xzKCkgaW4gYWRtaW5wYWNrLyB1c2VzIGhpc3RvcmljYWxseSBUWVBFRlVOQ19S RUNPUkQgYXMKcmV0dXJuIHR5cGUsIGFuZCBJIHN1c3BlY3QgdGhhdCBjaGFuZ2luZyBpdCBtYXkg Y2F1c2UgaXNzdWVzIGF0IHJ1bi10aW1lCndpdGggc29tZSBvZiBpdHMgcGFzdCB2ZXJzaW9ucywg ZG93biB0byAxLjAuCi0gZGJsaW5rLyB1c2VzIGEgd3JhcHBlciBmdW5jdGlvbiBkb2luZyBleGFj dGx5IHRoZSB3b3JrIG9mClNldFNpbmdsZUZ1bmNDYWxsKCkuICBIZXJlIHRoZSBzd2l0Y2ggc2hv dWxkIGJlIHBvc3NpYmxlLCBidXQgcmF0aGVyCmludmFzaXZlIHNvIGl0IGRvZXMgbm90IHNlZW0g dGhlIGV4dHJhIGJhY2twYXRjaCBtYWludGVuYW5jZSBjb3N0LgotIHRhYmxlZnVuYy8sIHNpbWls YXJseSwgdXNlcyBtdWx0aXBsZSBoZWxwZXIgZnVuY3Rpb25zIHdpdGggcG9ydGlvbnMgb2YKU2V0 U2luZ2xlRnVuY0NhbGwoKSBzcHJlYWQgYWNyb3NzIHRoZSBjb2RlIHBhdGhzIG9mIHRoaXMgbW9k dWxlLgoKQXV0aG9yOiBNZWxhbmllIFBsYWdlbWFuCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdy LmVzL20vQ0FBS1J1X2J2RFBKb0w5bUg2ZVl3dkJwUHRUR1F3YkR6ZkpiQ00tT2prU1pEdTV5VFBn QG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0 dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNWI4MTcwMzc4N2JmYzFlNjA3 MmM4ZTM3MTI1ZWJhMGM1NTk4YjgwNwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29u dHJpYi9hbWNoZWNrL3ZlcmlmeV9oZWFwYW0uYyAgICAgICAgICAgICAgICAgfCA0NiArKy0tLS0t LS0tLS0tLS0tCmNvbnRyaWIvZGJsaW5rL2RibGluay5jICAgICAgICAgICAgICAgICAgICAgICAg IHwgMjYgKy0tLS0tLS0tCmNvbnRyaWIvcGFnZWluc3BlY3QvYnJpbmZ1bmNzLmMgICAgICAgICAg ICAgICAgIHwgMzEgKystLS0tLS0tLS0KY29udHJpYi9wYWdlaW5zcGVjdC9naXN0ZnVuY3MuYyAg ICAgICAgICAgICAgICAgfCA2MCArKy0tLS0tLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wZ19zdGF0 X3N0YXRlbWVudHMvcGdfc3RhdF9zdGF0ZW1lbnRzLmMgfCAzMyArKy0tLS0tLS0tLS0KY29udHJp Yi9wZ3Jvd2xvY2tzL3Bncm93bG9ja3MuYyAgICAgICAgICAgICAgICAgfCAzNCArKy0tLS0tLS0t LS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvY29ubmVjdGlvbi5jICAgICAgICAgICAgICAgfCAzMSAr LS0tLS0tLS0tLQpjb250cmliL3htbDIveHBhdGguYyAgICAgICAgICAgICAgICAgICAgICAgICAg ICB8IDcyICsrKystLS0tLS0tLS0tLS0tLS0tLS0tLS0KOCBmaWxlcyBjaGFuZ2VkLCAzMiBpbnNl cnRpb25zKCspLCAzMDEgZGVsZXRpb25zKC0pCgo= --===============0585477220356278880==--