Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eJMSC-0001Wa-LD for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Nov 2017 16:40:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eJMSC-0006iv-1W for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Nov 2017 16:40:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eJMSB-0006ii-RP for pgsql-hackers@lists.postgresql.org; Mon, 27 Nov 2017 16:40:19 +0000 Received: from lb2-smtp-cloud7.xs4all.net ([194.109.24.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eJMS4-0007zt-Ti for pgsql-hackers@postgresql.org; Mon, 27 Nov 2017 16:40:19 +0000 Received: from webmailclassic.xs4all.nl ([IPv6:2001:888:0:22:194:109:20:203]) by smtp-cloud7.xs4all.net with ESMTPA id JMS3ef5GXVNbYJMS3e2ZXn; Mon, 27 Nov 2017 17:40:11 +0100 Received: from gateway-1-30.erasmusmc.nl ([156.83.1.30]) by webmailclassic.xs4all.nl with HTTP (HTTP/1.1 POST); Mon, 27 Nov 2017 17:40:08 +0100 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_c6d15dd0072a4a67be506aa5f69494bc" Date: Mon, 27 Nov 2017 17:40:08 +0100 From: Erik Rijkers To: Oliver Ford Cc: Pg Hackers Subject: Re: Add RANGE with values and exclusions clauses to the Window Functions In-Reply-To: References: Message-ID: <2c084c1c2bf599ceb2afa87874de8bc1@xs4all.nl> X-Sender: er@xs4all.nl User-Agent: XS4ALL Webmail X-CMAE-Envelope: MS4wfNmWd+T1jkHPtAfTD3IMmkczoFp1mGkaEg31oZWX1hoGbDqCCk3psQ0lxM81n1KzqQYg4qJzxzOaxr8JsG5I8HR0N2bNPzR/VN2/6b8WA69qLb0b3We7 0pd/ZH6weVgMECbNpZ3AUjuWgTDJ6PfivtRN/fShrUadKiJ5GTuGCI6lAdo0XXvXpuJyBTOG1Nm1yyLpcfWcatq+v0mKsCXxwK8pz7V6fbi7Zv29R+wpsp2s tUf7m/0f+ZZBiB4JvLWYnFn0FMnkQwwKNjuvhwmjmzM= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_c6d15dd0072a4a67be506aa5f69494bc Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed On 2017-11-27 17:34, Erik Rijkers wrote: > On 2017-11-27 16:01, Oliver Ford wrote: >> Attached is it in bare diff form. > > [0001-window-frame-v3.patch] > > Thanks, that did indeed fix it: > > make && make check now ok. > > There were errors in the doc build (unmatched tags); I fixed them in > the attached doc-patch (which should go on top of yours). 0001-window-frame-v3-fixtags.diff now attached, I hope... --=_c6d15dd0072a4a67be506aa5f69494bc Content-Transfer-Encoding: base64 Content-Type: text/x-diff; name=0001-window-frame-v3-fixtags.diff Content-Disposition: attachment; filename=0001-window-frame-v3-fixtags.diff; size=4193 LS0tIGRvYy9zcmMvc2dtbC9zeW50YXguc2dtbC5vcmlnCTIwMTctMTEtMjcgMTc6MTk6MzAuMjUz ODEwOTQ0ICswMTAwCisrKyBkb2Mvc3JjL3NnbWwvc3ludGF4LnNnbWwJMjAxNy0xMS0yNyAxNzoy MDo1NS41MTU2MjY5MzEgKzAxMDAKQEAgLTE4MDUsOCArMTgwNSw4IEBACiAgICAgYW5kIHRoZSBv cHRpb25hbCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+ZnJhbWVfY2xhdXNlPC9yZXBs YWNlYWJsZT4KICAgICBjYW4gYmUgb25lIG9mCiA8c3lub3BzaXM+Ci17IFJBTkdFIHwgUk9XUyB9 IDxyZXBsYWNlYWJsZT5mcmFtZV9zdGFydDwvPiBbIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1l dGVyIj5mcmFtZV9leGNsdXNpb25fY2xhdXNlPC9yZXBsYWNlYWJsZT4gXQoteyBSQU5HRSB8IFJP V1MgfSBCRVRXRUVOIDxyZXBsYWNlYWJsZT5mcmFtZV9zdGFydDwvPiBBTkQgPHJlcGxhY2VhYmxl PmZyYW1lX2VuZDwvPiBbIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5mcmFtZV9leGNs dXNpb25fY2xhdXNlPC9yZXBsYWNlYWJsZT4gXQoreyBSQU5HRSB8IFJPV1MgfSA8cmVwbGFjZWFi bGU+ZnJhbWVfc3RhcnQ8L3JlcGxhY2VhYmxlPiBbIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1l dGVyIj5mcmFtZV9leGNsdXNpb25fY2xhdXNlPC9yZXBsYWNlYWJsZT4gXQoreyBSQU5HRSB8IFJP V1MgfSBCRVRXRUVOIDxyZXBsYWNlYWJsZT5mcmFtZV9zdGFydDwvcmVwbGFjZWFibGU+IEFORCA8 cmVwbGFjZWFibGU+ZnJhbWVfZW5kPC9yZXBsYWNlYWJsZT4gWyA8cmVwbGFjZWFibGUgY2xhc3M9 InBhcmFtZXRlciI+ZnJhbWVfZXhjbHVzaW9uX2NsYXVzZTwvcmVwbGFjZWFibGU+IF0KIDwvc3lu b3BzaXM+CiAgICAgd2hlcmUgPHJlcGxhY2VhYmxlPmZyYW1lX3N0YXJ0PC9yZXBsYWNlYWJsZT4g YW5kIDxyZXBsYWNlYWJsZT5mcmFtZV9lbmQ8L3JlcGxhY2VhYmxlPiBjYW4gYmUKICAgICBvbmUg b2YKQEAgLTE4MTcsNyArMTgxNyw3IEBACiA8cmVwbGFjZWFibGU+dmFsdWU8L3JlcGxhY2VhYmxl PiBGT0xMT1dJTkcKIFVOQk9VTkRFRCBGT0xMT1dJTkcKIDwvc3lub3BzaXM+Ci0gICAgd2hlcmUg dGhlIG9wdGlvbmFsIDxyZXBsYWNlYWJsZT5mcmFtZV9leGNsdXNpb25fY2xhdXNlPC8+IGNhbiBi ZSBvbmUgb2YKKyAgICB3aGVyZSB0aGUgb3B0aW9uYWwgPHJlcGxhY2VhYmxlPmZyYW1lX2V4Y2x1 c2lvbl9jbGF1c2U8L3JlcGxhY2VhYmxlPiBjYW4gYmUgb25lIG9mCiA8c3lub3BzaXM+CiBFWENM VURFIENVUlJFTlQgUk9XCiBFWENMVURFIFRJRVMKQEAgLTE4ODgsMjQgKzE4ODgsMjQgQEAKIAog ICAgPHBhcmE+CiAgICAgVGhlIDxyZXBsYWNlYWJsZT52YWx1ZTwvcmVwbGFjZWFibGU+IDxsaXRl cmFsPlBSRUNFRElORzwvbGl0ZXJhbD4gYW5kCi0gICAgPHJlcGxhY2VhYmxlPnZhbHVlPC8+IDxs aXRlcmFsPkZPTExPV0lORzwvPiBjYXNlcywgd2hlbiB1c2VkCi0gICAgaW4gPGxpdGVyYWw+Uk9X UzwvPiBtb2RlLCBpbmRpY2F0ZSB0aGF0IHRoZSBmcmFtZSBzdGFydHMgb3IgZW5kcyB0aGUgc3Bl Y2lmaWVkCi0gICAgbnVtYmVyIG9mIHJvd3MgYmVmb3JlIG9yIGFmdGVyIHRoZSBjdXJyZW50IHJv dy4gSW4gPGxpdGVyYWw+Uk9XUzwvPiBtb2RlLAotICAgIDxyZXBsYWNlYWJsZT52YWx1ZTwvPiBt dXN0IGJlIGFuIGludGVnZXIgZXhwcmVzc2lvbiBub3QgY29udGFpbmluZyBhbnkgdmFyaWFibGVz LAorICAgIDxyZXBsYWNlYWJsZT52YWx1ZTwvcmVwbGFjZWFibGU+IDxsaXRlcmFsPkZPTExPV0lO RzwvbGl0ZXJhbD4gY2FzZXMsIHdoZW4gdXNlZAorICAgIGluIDxsaXRlcmFsPlJPV1M8L2xpdGVy YWw+IG1vZGUsIGluZGljYXRlIHRoYXQgdGhlIGZyYW1lIHN0YXJ0cyBvciBlbmRzIHRoZSBzcGVj aWZpZWQKKyAgICBudW1iZXIgb2Ygcm93cyBiZWZvcmUgb3IgYWZ0ZXIgdGhlIGN1cnJlbnQgcm93 LiBJbiA8bGl0ZXJhbD5ST1dTPC9saXRlcmFsPiBtb2RlLAorICAgIDxyZXBsYWNlYWJsZT52YWx1 ZTwvcmVwbGFjZWFibGU+IG11c3QgYmUgYW4gaW50ZWdlciBleHByZXNzaW9uIG5vdCBjb250YWlu aW5nIGFueSB2YXJpYWJsZXMsCiAgICAgYWdncmVnYXRlIGZ1bmN0aW9ucywgb3Igd2luZG93IGZ1 bmN0aW9ucy4KLSAgICBXaGVuIHVzZWQgaW4gPGxpdGVyYWw+UkFOR0U8Lz4gbW9kZSwgdGhleSBp bmRpY2F0ZSB0aGF0IHRoZSBmcmFtZSBzdGFydHMgb3IgZW5kcyB3aGVuIHRoZSB2YWx1ZSBvZgot ICAgIGVhY2ggcm93J3MgT1JERVIgQlkgY29sdW1uIGlzIHdpdGhpbiB0aGUgc3RhcnQgdmFsdWUg YW5kIGVuZCB2YWx1ZSBib3VuZHMuIEluIDxsaXRlcmFsPlJBTkdFPC8+IG1vZGUsCi0gICAgPHJl cGxhY2VhYmxlPnZhbHVlPC8+IGNhbiBiZSBlaXRoZXIgYW4gaW50ZWdlciBleHByZXNzaW9uIG9y IGEgZGF0ZS90aW1lIGludGVydmFsLgotICAgIEluIDxsaXRlcmFsPlJBTkdFPC8+IG1vZGUsIHRo ZXJlIG11c3QgYmUgZXhhY3RseSBvbmUgT1JERVIgQlkgY29sdW1uIGFuZCBpZiB0aGUgY29sdW1u IGlzIGFuIGludGVnZXIgY29sdW1uLAotICAgIHRoZW4gPHJlcGxhY2VhYmxlPnZhbHVlPC8+IG11 c3QgYmUgYW4gaW50ZWdlci4KLSAgICBJZiBpdCBpcyBhIGRhdGUvdGltZSBjb2x1bW4sIHRoZW4g PHJlcGxhY2VhYmxlPnZhbHVlPC8+IG11c3QgYmUgYW4gaW50ZXJ2YWwuIEluIGJvdGggbW9kZXMs CisgICAgV2hlbiB1c2VkIGluIDxsaXRlcmFsPlJBTkdFPC9saXRlcmFsPiBtb2RlLCB0aGV5IGlu ZGljYXRlIHRoYXQgdGhlIGZyYW1lIHN0YXJ0cyBvciBlbmRzIHdoZW4gdGhlIHZhbHVlIG9mCisg ICAgZWFjaCByb3cncyBPUkRFUiBCWSBjb2x1bW4gaXMgd2l0aGluIHRoZSBzdGFydCB2YWx1ZSBh bmQgZW5kIHZhbHVlIGJvdW5kcy4gSW4gPGxpdGVyYWw+UkFOR0U8L2xpdGVyYWw+IG1vZGUsCisg ICAgPHJlcGxhY2VhYmxlPnZhbHVlPC9yZXBsYWNlYWJsZT4gY2FuIGJlIGVpdGhlciBhbiBpbnRl Z2VyIGV4cHJlc3Npb24gb3IgYSBkYXRlL3RpbWUgaW50ZXJ2YWwuCisgICAgSW4gPGxpdGVyYWw+ UkFOR0U8L2xpdGVyYWw+IG1vZGUsIHRoZXJlIG11c3QgYmUgZXhhY3RseSBvbmUgT1JERVIgQlkg Y29sdW1uIGFuZCBpZiB0aGUgY29sdW1uIGlzIGFuIGludGVnZXIgY29sdW1uLAorICAgIHRoZW4g PHJlcGxhY2VhYmxlPnZhbHVlPC9yZXBsYWNlYWJsZT4gbXVzdCBiZSBhbiBpbnRlZ2VyLgorICAg IElmIGl0IGlzIGEgZGF0ZS90aW1lIGNvbHVtbiwgdGhlbiA8cmVwbGFjZWFibGU+dmFsdWU8L3Jl cGxhY2VhYmxlPiBtdXN0IGJlIGFuIGludGVydmFsLiBJbiBib3RoIG1vZGVzLAogICAgIHRoZSB2 YWx1ZSBtdXN0IG5vdCBiZSBudWxsIG9yIG5lZ2F0aXZlOyBidXQgaXQgY2FuIGJlIHplcm8sIHdo aWNoIGp1c3Qgc2VsZWN0cyB0aGUgY3VycmVudCByb3cuCiAgICA8L3BhcmE+CiAKICAgIDxwYXJh PgotICAgIEZvciB0aGUgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPmZyYW1lX2V4Y2x1 c2lvbl9jbGF1c2U8L3JlcGxhY2VhYmxlPiwgPGxpdGVyYWw+RVhDTFVERSBDVVJSRU5UIFJPVzwv PgotICAgIGV4Y2x1ZGVzIHRoZSBjdXJyZW50IHJvdyBmcm9tIHRoZSBmcmFtZS4gPGxpdGVyYWw+ RVhDTFVERSBUSUVTPC8+IGV4Y2x1ZGVzIGFueSBwZWVycyBvZiB0aGUgY3VycmVudCByb3cgZnJv bSB0aGUKLSAgICBmcmFtZS4gPGxpdGVyYWw+RVhDTFVERSBOTyBPVEhFUlM8Lz4gZG9lcyBub3Ro aW5nLCBidXQgaXMgcHJvdmlkZWQgaW4gb3JkZXIgdG8gb3B0aW9uYWxseSBkb2N1bWVudCB0aGUg aW50ZW50aW9uCisgICAgRm9yIHRoZSA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+ZnJh bWVfZXhjbHVzaW9uX2NsYXVzZTwvcmVwbGFjZWFibGU+LCA8bGl0ZXJhbD5FWENMVURFIENVUlJF TlQgUk9XPC9saXRlcmFsPgorICAgIGV4Y2x1ZGVzIHRoZSBjdXJyZW50IHJvdyBmcm9tIHRoZSBm cmFtZS4gPGxpdGVyYWw+RVhDTFVERSBUSUVTPC9saXRlcmFsPiBleGNsdWRlcyBhbnkgcGVlcnMg b2YgdGhlIGN1cnJlbnQgcm93IGZyb20gdGhlCisgICAgZnJhbWUuIDxsaXRlcmFsPkVYQ0xVREUg Tk8gT1RIRVJTPC9saXRlcmFsPiBkb2VzIG5vdGhpbmcsIGJ1dCBpcyBwcm92aWRlZCBpbiBvcmRl ciB0byBvcHRpb25hbGx5IGRvY3VtZW50IHRoZSBpbnRlbnRpb24KICAgICBub3QgdG8gZXhjbHVk ZSBhbnkgb3RoZXIgcm93cy4KICAgIDwvcGFyYT4KIAo= --=_c6d15dd0072a4a67be506aa5f69494bc--