Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v4U9H-00GbgC-1e for pgsql-committers@arkaria.postgresql.org; Fri, 03 Oct 2025 00:59:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v4U9F-00AEZq-33 for pgsql-committers@arkaria.postgresql.org; Fri, 03 Oct 2025 00:59:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v4U9E-00AEZi-Rm for pgsql-committers@lists.postgresql.org; Fri, 03 Oct 2025 00:59:49 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v4U9C-0017kR-0E for pgsql-committers@lists.postgresql.org; Fri, 03 Oct 2025 00:59:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=75IOwdGfMDaorKDlhSBWC7+ZIvg2BXLzDecCBrVOkpA=; b=tIZsQJqEy1E4xH55F8CRb3FrNN QZjGlrJkK4XCoI9mZLrzJWHv1tMQcLa9RuXBITRmsnWIVUdcZpxpI0v1Ypy6sGO5oQQbObHPSjKYd l8hpkO641PXd9H2i35KkuJvQgY//3RrFv0i8v0knk7DEX5Mg58D99YDiEpk+iRjDzdtW6iYeKMbyA NqmpaSFHolUnZBMbDUTPRFmglnf/SMpO1z8I071ZM3PjegGRxQ1W0FR6WxKvj8MTmE2TViff3xATr aY6vduBUvkd1MsuROmmQrdagOzn8xm5Oxxn+5wrfxu9MculFNSXivRNg/iJ+QvvGwsBI7w4eJblKS aG6G87Yw==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v4U9A-00373s-Vt for pgsql-committers@lists.postgresql.org; Fri, 03 Oct 2025 00:59:46 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v4U9B-001BCJ-00 for pgsql-committers@lists.postgresql.org; Fri, 03 Oct 2025 00:59:45 +0000 Content-Type: multipart/mixed; boundary="===============7779147194822946214==" MIME-Version: 1.0 From: Tatsuo Ishii To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add IGNORE NULLS/RESPECT NULLS option to Window functions. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 03 Oct 2025 00:59:45 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7779147194822946214== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIElHTk9SRSBOVUxMUy9SRVNQRUNUIE5VTExTIG9wdGlvbiB0byBXaW5kb3cgZnVuY3Rpb25z LgoKQWRkIElHTk9SRSBOVUxMUy9SRVNQRUNUIE5VTExTIG9wdGlvbiAobnVsbCB0cmVhdG1lbnQg Y2xhdXNlKSB0byBsZWFkLApsYWcsIGZpcnN0X3ZhbHVlLCBsYXN0X3ZhbHVlIGFuZCBudGhfdmFs dWUgd2luZG93IGZ1bmN0aW9ucy4gIElmCnVuc3BlY2lmaWVkLCB0aGUgZGVmYXVsdCBpcyBSRVNQ RUNUIE5VTExTIHdoaWNoIGluY2x1ZGVzIE5VTEwgdmFsdWVzCmluIGFueSByZXN1bHQgY2FsY3Vs YXRpb24uIElHTk9SRSBOVUxMUyBpZ25vcmVzIE5VTEwgdmFsdWVzLgoKQnVpbHQtaW4gd2luZG93 IGZ1bmN0aW9ucyBhcmUgbW9kaWZpZWQgdG8gY2FsbCBuZXcgQVBJCldpbkNoZWNrQW5kSW5pdGlh bGl6ZU51bGxUcmVhdG1lbnQoKSB0byBpbmRpY2F0ZSB3aGV0aGVyIHRoZXkgYWNjZXB0CklHTk9S RSBOVUxMUy9SRVNQRUNUIE5VTExTIG9wdGlvbiBvciBub3QgKHRoZSBBUEkgY2FuIGJlIGNhbGxl ZCBieQp1c2VyIGRlZmluZWQgd2luZG93IGZ1bmN0aW9ucyBhcyB3ZWxsKS4gIElmIFdpbkdldEZ1 bmNBcmdJblBhcnRpdGlvbidzCmFsbG93TnVsbFRyZWF0bWVudCBhcmd1bWVudCBpcyB0cnVlIGFu ZCBJR05PUkUgTlVMTFMgb3B0aW9uIGlzIGdpdmVuLApXaW5HZXRGdW5jQXJnSW5QYXJ0aXRpb24o KSBvciBXaW5HZXRGdW5jQXJnSW5GcmFtZSgpIHdpbGwgcmV0dXJuCmV2YWx1YXRlZCBmdW5jdGlv bidzIGFyZ3VtZW50IGV4cHJlc3Npb24gb24gc3BlY2lmaWVkIG5vbiBOVUxMIHJvdyAoaWYKaXQg ZXhpc3RzKSBpbiB0aGUgcGFydGl0aW9uIG9yIHRoZSBmcmFtZS4KCldoZW4gSUdOT1JFIE5VTExT IG9wdGlvbiBpcyBnaXZlbiwgd2luZG93IGZ1bmN0aW9ucyBuZWVkIHRvIHZpc2l0IGFuZApldmFs dWF0ZSBzYW1lIHJvd3Mgb3ZlciBhbmQgb3ZlciBhZ2FpbiB0byBsb29rIGZvciBub24gbnVsbCBy b3dzLiBUbwptaXRpZ2F0ZSB0aGUgaXNzdWUsIDItYml0IG5vdCBudWxsIGluZm9ybWF0aW9uIGFy cmF5IGlzIGNyZWF0ZWQgd2hpbGUKZXhlY3V0aW5nIHdpbmRvdyBmdW5jdGlvbnMgdG8gcmVtZW1i ZXIgd2hldGhlciB0aGUgcm93IGhhcyBiZWVuCmFscmVhZHkgZXZhbHVhdGVkIHRvIE5VTEwgb3Ig Tk9UIE5VTEwuIElmIGFscmVhZHkgZXZhbHVhdGVkLCB3ZSBjb3VsZApza2lwIHRoZSBldmFsdWF0 aW9uIHdvcmssIHRodXMgd2UgY291bGQgZ2V0IGJldHRlciBwZXJmb3JtYW5jZS4KCkF1dGhvcjog T2xpdmVyIEZvcmQgPG9qZm9yZEBnbWFpbC5jb20+CkNvLWF1dGhvcmVkLWJ5OiBUYXRzdW8gSXNo aWkgPGlzaGlpQHBvc3RncmVzcWwub3JnPgpSZXZpZXdlZC1ieTogS3Jhc2l5YW4gQW5kcmVldiA8 a3Jhc2l5YW5AZ21haWwuY29tPgpSZXZpZXdlZC1ieTogQW5kcmV3IEdpZXJ0aCA8YW5kcmV3QHRh bzExLnJpZGRsZXMub3JnLnVrPgpSZXZpZXdlZC1ieTogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBh LnVzPgpSZXZpZXdlZC1ieTogRGF2aWQgRmV0dGVyIDxkYXZpZEBmZXR0ZXIub3JnPgpSZXZpZXdl ZC1ieTogVmlrIEZlYXJpbmcgPHZpa0Bwb3N0Z3Jlc2ZyaWVuZHMub3JnPgpSZXZpZXdlZC1ieTog IkRhdmlkIEcuIEpvaG5zdG9uIiA8ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb20+ClJldmlld2Vk LWJ5OiBDaGFvIExpIDxsaWNAaGlnaGdvLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3Iu ZXMvbS9mbGF0L0NBR01WT2RzYnRSd0VfNCt2OHpqSDFkOXhmb3ZEZVFBR0xrUF9CNms2OV9Wb0ZF Z1gtQUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzI1YTMwYmJkNDIzNWE0 OWM4NTQwMzZjODRmZTkwZjJiYzVhODc2NTIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CmRvYy9zcmMvc2dtbC9mdW5jL2Z1bmMtd2luZG93LnNnbWwgICB8ICAzOCArLS0KZG9jL3NyYy9z Z21sL3N5bnRheC5zZ21sICAgICAgICAgICAgIHwgIDEwICstCnNyYy9iYWNrZW5kL2NhdGFsb2cv c3FsX2ZlYXR1cmVzLnR4dCB8ICAgMiArLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlV2luZG93 QWdnLmMgfCA0NjcgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKystLS0Kc3JjL2JhY2tl bmQvb3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jIHwgICAxICsKc3JjL2JhY2tlbmQvcGFyc2VyL2dy YW0ueSAgICAgICAgICAgIHwgIDE5ICstCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9mdW5jLmMg ICAgICB8ICAgOSArCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9ydWxldXRpbHMuYyAgICB8ICAgNyAr LQpzcmMvYmFja2VuZC91dGlscy9hZHQvd2luZG93ZnVuY3MuYyAgfCAgMTAgKwpzcmMvaW5jbHVk ZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAgfCAgIDEgKwpzcmMvaW5jbHVkZS9ub2Rlcy9wcmlt bm9kZXMuaCAgICAgICAgfCAgMTMgKwpzcmMvaW5jbHVkZS9wYXJzZXIva3dsaXN0LmggICAgICAg ICAgfCAgIDIgKwpzcmMvaW5jbHVkZS93aW5kb3dhcGkuaCAgICAgICAgICAgICAgfCAgIDYgKwpz cmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3dpbmRvdy5vdXQgfCA0MDYgKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3dpbmRvdy5zcWwgICAgICB8IDE2 MiArKysrKysrKysrKysKMTUgZmlsZXMgY2hhbmdlZCwgMTA5MiBpbnNlcnRpb25zKCspLCA2MSBk ZWxldGlvbnMoLSkKCg== --===============7779147194822946214==--