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 1vsn0n-000UKa-2Z for pgsql-committers@arkaria.postgresql.org; Wed, 18 Feb 2026 19:15:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vsn0m-00HQgi-2y for pgsql-committers@arkaria.postgresql.org; Wed, 18 Feb 2026 19:15:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vsn0m-00HQga-29 for pgsql-committers@lists.postgresql.org; Wed, 18 Feb 2026 19:15:00 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vsn0j-000000000W4-24Ax for pgsql-committers@lists.postgresql.org; Wed, 18 Feb 2026 19:15:00 +0000 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 1vsn0i-0000pS-0c for pgsql-committers@lists.postgresql.org; Wed, 18 Feb 2026 19:14:56 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vsn0i-0000d8-0f for pgsql-committers@lists.postgresql.org; Wed, 18 Feb 2026 19:14:56 +0000 Content-Type: multipart/mixed; boundary="===============8642588667298409785==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Simplify creation of built-in functions with default arguments. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 18 Feb 2026 19:14:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8642588667298409785== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2ltcGxpZnkgY3JlYXRpb24gb2YgYnVpbHQtaW4gZnVuY3Rpb25zIHdpdGggZGVmYXVsdCBhcmd1 bWVudHMuCgpVcCB0byBub3csIHRvIGNyZWF0ZSBzdWNoIGEgZnVuY3Rpb24sIG9uZSBoYWQgdG8g bWFrZSBhIHBnX3Byb2MuZGF0CmVudHJ5IGFuZCB0aGVuIG92ZXJ3cml0ZSBpdCB3aXRoIGEgQ1JF QVRFIE9SIFJFUExBQ0UgY29tbWFuZCBpbgpzeXN0ZW1fZnVuY3Rpb25zLnNxbC4gIFRoYXQncyBl cnJvci1wcm9uZSAoY2YuIGJ1ZyAjMTk0MDkpIGFuZApyZXN1bHRzIGluIGxlYXZpbmcgZGVhZCBy b3dzIGluIHRoZSBpbml0aWFsIGNvbnRlbnRzIG9mIHBnX3Byb2MuCgpNYW51YWwgbWFpbnRlbmFu Y2Ugb2YgcGdfbm9kZV90cmVlIHN0cmluZ3Mgc2VlbXMgZW50aXJlbHkgaW1wcmFjdGljYWwsCmFu ZCBwYXJzaW5nIGV4cHJlc3Npb25zIGR1cmluZyBib290c3RyYXAgd291bGQgYmUgZXh0cmVtZWx5 IGRpZmZpY3VsdAphcyB3ZWxsLiAgQnV0IEFuZHJlcyBGcmV1bmQgb2JzZXJ2ZWQgdGhhdCBhbGwg dGhlIGN1cnJlbnQgdXNlLWNhc2VzCmFyZSBzaW1wbGUgY29uc3RhbnRzLCBhbmQgYnVpbGRpbmcg YSBDb25zdCBub2RlIGlzIHdlbGwgd2l0aGluIHRoZQpjYXBhYmlsaXRpZXMgb2YgYm9vdHN0cmFw IG1vZGUuICBTbyB0aGlzIHBhdGNoIGludmVudHMgYSBzcGVjaWFsIGNhc2U6CmlmIGJvb3RzdHJh cCBtb2RlIGlzIGFza2VkIHRvIGluZ2VzdCBhIG5vbi1udWxsIHZhbHVlIGZvcgpwZ19wcm9jLnBy b2FyZ2RlZmF1bHRzICh3aGljaCB3b3VsZCBvdGhlcndpc2UgZmFpbCBpbgpwZ19ub2RlX3RyZWVf aW4pLCBpdCBwYXJzZXMgdGhlIHZhbHVlIGFzIGFuIGFycmF5IGxpdGVyYWwgYW5kIHRoZW4KZmVl ZHMgdGhlIGVsZW1lbnQgc3RyaW5ncyB0byB0aGUgaW5wdXQgZnVuY3Rpb25zIGZvciB0aGUgY29y cmVzcG9uZGluZwpwYXJhbWV0ZXIgdHlwZXMuICBUaGVuIHdlIGNhbiBidWlsZCBhIHN1aXRhYmxl IHBnX25vZGVfdHJlZSBzdHJpbmcKd2l0aCBqdXN0IGEgZmV3IG1vcmUgbGluZXMgb2YgY29kZS4K ClRoaXMgYWxsb3dzIHJlbW92aW5nIGFsbCB0aGUgc3lzdGVtX2Z1bmN0aW9ucy5zcWwgZW50cmll cyB0aGF0IGFyZQpqdXN0IHRoZXJlIHRvIHNldCB1cCBkZWZhdWx0IGFyZ3VtZW50cywgcmVwbGFj aW5nIHRoZW0gd2l0aApwcm9hcmdkZWZhdWx0cyBmaWVsZHMgaW4gcGdfcHJvYy5kYXQgZW50cmll cy4gIFRoZSBvbGQgdGVjaG5pcXVlCnJlbWFpbnMgYXZhaWxhYmxlIGluIGNhc2Ugc29tZW9uZSBu ZWVkcyBhIG5vbi1jb25zdGFudCBkZWZhdWx0LgoKVGhlIGluaXRpYWwgY29udGVudHMgb2YgcGdf cHJvYyBhcmUgZGVtb25zdHJhYmx5IHRoZSBzYW1lIGFmdGVyCnRoaXMgcGF0Y2gsIGV4Y2VwdCB0 aGF0ICgxKSBqc29uX3N0cmlwX251bGxzIGFuZCBqc29uYl9zdHJpcF9udWxscwpub3cgaGF2ZSB0 aGUgY29ycmVjdCBwcm92b2xhdGlsZSBzZXR0aW5nLCBhcyBwZXIgYnVnICMxOTQwOTsKKDIpIHBn X3Rlcm1pbmF0ZV9iYWNrZW5kLCBtYWtlX2ludGVydmFsLCBhbmQgZHJhbmRvbV9ub3JtYWwKbm93 IGhhdmUgZGVmYXVsdHMgdGhhdCBkb24ndCBpbmNsdWRlIGEgdHlwZSBjb2VyY2lvbiwgd2hpY2gg aXMKaG93IHRoZXkgc2hvdWxkIGhhdmUgYmVlbiBhbGwgYWxvbmcuCgpJbiBwYXNzaW5nLCByZW1v dmUgc29tZSB1bnVzZWQgZW50cmllcyBmcm9tIGJvb3RzdHJhcC5jJ3MgVHlwSW5mb1tdCmFycmF5 LiAgSSBoYWQgdG8gYWRkIHNvbWUgbmV3IG9uZXMgYmVjYXVzZSB3ZSdsbCBub3cgbmVlZCBhbiBl bnRyeSBmb3IKZWFjaCBkZWZhdWx0LXBvc3Nlc3Npbmcgc3lzdGVtIGZ1bmN0aW9uIHBhcmFtZXRl ciwgYnV0IHdlIHNob3VsZG4ndApjYXJyeSBtb3JlIHRoYW4gd2UgbmVlZCB0aGVyZTsgaXQncyBq dXN0IGEgbWFpbnRlbmFuY2UgZ290Y2hhLgoKQnVnOiAjMTk0MDkKUmVwb3J0ZWQtYnk6IEx1Y2lv IENoaWVzc2kgPGx1Y2lvLmNoaWVzc2lAdHJ1c3RseS5jb20+CkF1dGhvcjogVG9tIExhbmUgPHRn bEBzc3MucGdoLnBhLnVzPgpBdXRob3I6IEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUu bmV0PgpSZXZpZXdlZC1ieTogQW5kcmVzIEZyZXVuZCA8YW5kcmVzQGFuYXJhemVsLmRlPgpEaXNj dXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE4MzI5MmJiLTQ4OTEtNGM5Ni1hM2NhLWU3OGI1 ZTBlMTM1OEBkdW5zbGFuZS5uZXQKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xOTQw OS1lMTZjZDI2MDVlNTlhNGFmQHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv NzU5YjAzYjI0Y2U5NmYwYmE2ZDczNGI1NzBkMWE2ZjRhMGZiMTE3NwoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL2JraS5zZ21sICAgICAgICAgICAgICAgICAgICB8 ICAzNCArKystCnNyYy9iYWNrZW5kL2Jvb3RzdHJhcC9ib290c3RyYXAuYyAgICAgICAgfCAxNzcg KysrKysrKysrKysrKysrKy0tLQpzcmMvYmFja2VuZC9jYXRhbG9nL3N5c3RlbV9mdW5jdGlvbnMu c3FsIHwgMjgzICstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvdXRp bHMvY2FjaGUvbHN5c2NhY2hlLmMgICAgICB8ICAgNCArLQpzcmMvaW5jbHVkZS9ib290c3RyYXAv Ym9vdHN0cmFwLmggICAgICAgIHwgICAzICstCnNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lv bi5oICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wcm9jLmRhdCAgICAg ICAgICB8ICA4NiArKysrKysrKy0tCjcgZmlsZXMgY2hhbmdlZCwgMjYzIGluc2VydGlvbnMoKyks IDMyNiBkZWxldGlvbnMoLSkKCg== --===============8642588667298409785==--