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.96) (envelope-from ) id 1vYKkx-0016UF-02 for pgsql-committers@arkaria.postgresql.org; Wed, 24 Dec 2025 09:02:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vYKkw-0049GE-01 for pgsql-committers@arkaria.postgresql.org; Wed, 24 Dec 2025 09:02:06 +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.96) (envelope-from ) id 1vYKkv-0049Fp-2F for pgsql-committers@lists.postgresql.org; Wed, 24 Dec 2025 09:02:06 +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 1vYKku-002N3D-1H for pgsql-committers@lists.postgresql.org; Wed, 24 Dec 2025 09:02:05 +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=nCgd+HdnRjROdD3xgN/bx/mQJpiA/rwY/Bbhyzqhhzk=; b=WCxpzqD/4YEy8Ix5t0d5QmcTfj MGAtpc5J/wBME658mF/IDmtgm+u9lmHriebBrfl/JhTlViBkrGshKa5HF4ZPUfXNIWE5COn51qxAu 7oJ3z+BOSVjHnUH1G4bZSLeGTMyFNhJvz4MS0zgKyYEiR3aJCt0ITsceRWBCAGgVq9OtrGHF2ltsp sVT7UCH7bj1b72UYKB3ToLN071RwR1pweLY40t9pHnFTlio4eUqsfxlMTs24S/Bfp2/gFSVbBqSgM LBmes56jsrmZFMF/R8nbdLTAXPM2jSlmZ1SNK4TXOHGStF0EwJl94GZ/tRPyO/jMDLj+tFAzoW8Qr NMFdc7QQ==; 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.96) (envelope-from ) id 1vYKkt-006o5V-2y for pgsql-committers@lists.postgresql.org; Wed, 24 Dec 2025 09:02:03 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vYKkr-002PHB-14 for pgsql-committers@lists.postgresql.org; Wed, 24 Dec 2025 09:02:02 +0000 Content-Type: multipart/mixed; boundary="===============7080026630664404759==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Simplify COALESCE expressions using non-nullable arguments X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 24 Dec 2025 09:02:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7080026630664404759== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2ltcGxpZnkgQ09BTEVTQ0UgZXhwcmVzc2lvbnMgdXNpbmcgbm9uLW51bGxhYmxlIGFyZ3VtZW50 cwoKVGhlIENPQUxFU0NFIGZ1bmN0aW9uIHJldHVybnMgdGhlIGZpcnN0IG9mIGl0cyBhcmd1bWVu dHMgdGhhdCBpcyBub3QKbnVsbC4gIFdoZW4gYW4gYXJndW1lbnQgaXMgcHJvdmVuIG5vbi1udWxs LCBpZiBpdCBpcyB0aGUgZmlyc3QKbm9uLW51bGwtY29uc3RhbnQgYXJndW1lbnQsIHRoZSBlbnRp cmUgQ09BTEVTQ0UgZXhwcmVzc2lvbiBjYW4gYmUKcmVwbGFjZWQgYnkgdGhhdCBhcmd1bWVudC4g IElmIGl0IGlzIGEgc3Vic2VxdWVudCBhcmd1bWVudCwgYWxsCmZvbGxvd2luZyBhcmd1bWVudHMg Y2FuIGJlIGRyb3BwZWQsIHNpbmNlIHRoZXkgd2lsbCBuZXZlciBiZSByZWFjaGVkLgoKQ3VycmVu dGx5LCB3ZSBwZXJmb3JtIHRoaXMgc2ltcGxpZmljYXRpb24gb25seSBmb3IgQ29uc3QgYXJndW1l bnRzLgpUaGlzIHBhdGNoIGV4dGVuZHMgdGhlIHNpbXBsaWZpY2F0aW9uIHRvIHN1cHBvcnQgYW55 IGV4cHJlc3Npb24gdGhhdApjYW4gYmUgcHJvdmVuIG5vbi1udWxsYWJsZS4KClRoaXMgY2FuIGhl bHAgYXZvaWQgdGhlIG92ZXJoZWFkIG9mIGV2YWx1YXRpbmcgdW5yZWFjaGFibGUgYXJndW1lbnRz LgpJdCBjYW4gYWxzbyBsZWFkIHRvIGJldHRlciBwbGFucyB3aGVuIHRoZSBmaXJzdCBhcmd1bWVu dCBpcyBwcm92ZW4Kbm9uLW51bGxhYmxlIGFuZCByZXBsYWNlcyB0aGUgZXhwcmVzc2lvbiwgYXMg dGhlIHBsYW5uZXIgbm8gbG9uZ2VyIGhhcwp0byB0cmVhdCB0aGUgZXhwcmVzc2lvbiBhcyBub24t c3RyaWN0LCBhbmQgY2FuIGFsc28gbGV2ZXJhZ2UgaW5kZXgKc2NhbnMgb24gdGhlIHJlc3VsdGlu ZyBleHByZXNzaW9uLgoKVGhlcmUgaXMgYW4gZW5zdWluZyBwbGFuIGNoYW5nZSBpbiBnZW5lcmF0 ZWRfdmlydHVhbC5vdXQsIGFuZCB3ZSBoYXZlCnRvIG1vZGlmeSB0aGUgdGVzdCB0byBlbnN1cmUg dGhhdCBpdCBjb250aW51ZXMgdG8gdGVzdCB3aGF0IGl0IGlzCmludGVuZGVkIHRvLgoKQXV0aG9y OiBSaWNoYXJkIEd1byA8Z3VvZmVuZ2xpbnV4QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFRlbmRl ciBXYW5nIDx0bmRyd2FuZ0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBEYWdmaW5uIElsbWFyaSBN YW5uc8Ola2VyIDxpbG1hcmlAaWxtYXJpLm9yZz4KUmV2aWV3ZWQtYnk6IERhdmlkIFJvd2xleSA8 ZGdyb3dsZXltbEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBNYXRoZXVzIEFsY2FudGFyYSA8bWF0 aGV1c3NzaWx2OTdAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NB TWJXczQ5VWhQQmptK05ScHhlcmphZXVGS3lVWkpfQWpNM05CY1NZSzJKZ1o2VlRFUUBtYWlsLmdt YWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dp dC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzEwYzRmZTA3NGE5MmVjY2Y5ZmE2ZjdhMzlm ZTRkM2Y5N2I5Yjg3ZTIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5k L29wdGltaXplci91dGlsL2NsYXVzZXMuYyAgICAgICAgICAgIHwgMTggKysrKysrKy0tLQpzcmMv dGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVyYXRlZF92aXJ0dWFsLm91dCB8IDQ4ICsrKysrKysr KysrKystLS0tLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wcmVkaWNhdGUub3V0 ICAgICAgICAgfCAzMyArKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9nZW5l cmF0ZWRfdmlydHVhbC5zcWwgICAgICB8IDExICsrKy0tLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9w cmVkaWNhdGUuc3FsICAgICAgICAgICAgICB8IDIwICsrKysrKysrKysrCjUgZmlsZXMgY2hhbmdl ZCwgOTcgaW5zZXJ0aW9ucygrKSwgMzMgZGVsZXRpb25zKC0pCgo= --===============7080026630664404759==--