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 1tcElE-00GMfm-Rm for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Jan 2025 02:22:01 +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 1tcEkE-008xCs-TT for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Jan 2025 02:20:58 +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.94.2) (envelope-from ) id 1tcEkE-008xCk-IW for pgsql-hackers@lists.postgresql.org; Mon, 27 Jan 2025 02:20:58 +0000 Received: from mail-ua1-x930.google.com ([2607:f8b0:4864:20::930]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tcEkB-001gks-0m for pgsql-hackers@postgresql.org; Mon, 27 Jan 2025 02:20:57 +0000 Received: by mail-ua1-x930.google.com with SMTP id a1e0cc1a2514c-85bad9e0214so1602190241.3 for ; Sun, 26 Jan 2025 18:20:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1737944453; x=1738549253; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=+lxTAQD2eOJ8jnBb6ueutPxTyLp28JsiA0LbqT/+bBU=; b=Kj9BWSrfCCx5kZmfodP+CWonCmsRgj387MDNJSb6G5oO5RwCLg4eZEk8YmqLxD0Ac+ pDh8e9HgpmHz4UipQOFN+MhZ++z52DHQ4BxRDYx5keCSnlEsvuHo0DdCAW9K22Ez7v86 4a8LQJPBf2EYTQfonTjRMUg8ZTHqjbpgnqfqaWE0mTplvhzmFg76T36XlKMPbIEpddwf WOCKtgqduCOtonHekTMXcap+3MifELb55ddEsPeLVLyi4YuSOMmu5fTPMUa7qdwHsp+8 sZjaL4I5TOB7GXgCg0RleAmixumwgLGmLifI+LXsuoyjE8wbKkzB7YQJvBj6IMrXpPmn hkiA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737944453; x=1738549253; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=+lxTAQD2eOJ8jnBb6ueutPxTyLp28JsiA0LbqT/+bBU=; b=tzCj/6k3UOcrMo+7COktMepCGt9pqlHUaRDV2iXdD54MxkQp9zt2m4aexfXIZc1NiV q44l/NM++js6fuwEPCapwcDNeo0lnr9j1Je6ps6UaGOhhZuI5crMpiVEziCcnf27tQq+ nB5GoeZAfAmiCSBEC8Zb3JAcIUYfOEnbDFDYZVHMI9wfIYKcTsIkOW9y7Tz0TBxLBwGj MffkOY86JVRiPE9nS6TUa929zEWbNg6VLCVJzSthvMUBxxqZhc08+M7Kve1hmawODZso VD2Fbi4eo0NCd0YJEVjdR9yKa1HuVaUVx6Z0Ma0X6QQY3Jw3+ea+72eOXlVLjGoh0F5m 3Kew== X-Gm-Message-State: AOJu0YxTJ0lk/tm2uOiQ572FrI+4ItUtUXsIgGkyPVYUZhmxl0vD7p3C xuYH/Vgv1wG29AM5XroNOmMWvxKkJ16r/eNBGh2DywCkVijfbviWFfcQhTcq1pecXQy+7eSaB8I AKuVcMzlsldzu+Bq/risF6WwAQZPfYhOg X-Gm-Gg: ASbGncuhcOdM1eruar+Nz2Bo5I6gc54zOTDhsZy0CIQ1a+kXqF2Ga/0aGzfISWjomGw jFpVPKBREF2Uw7njM9Y+36Dzmt+EtlTNQBpcMOCm0MfzJes0k/hjlGJHTvh/hOotjxtC0czI/M+ pEWqPxLp3OmgB1b4KS X-Google-Smtp-Source: AGHT+IHididG7JONNSYJMaaB+RSegTu7qr3gSMVZRYR6qxKOvOx6HqPk006GuJe0NrpeCEOAOfIu3H3MKAhKzRFCn94= X-Received: by 2002:a05:6102:442b:b0:4b6:4502:4a84 with SMTP id ada2fe7eead31-4b690b7c0a5mr35042810137.2.1737944453505; Sun, 26 Jan 2025 18:20:53 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: jian he Date: Mon, 27 Jan 2025 10:20:16 +0800 X-Gm-Features: AWEUYZknbZgT6SzapwLHOKdxmyUyj1jXj7le-LfwfU6jNv4q3rGzenV8FVJaUx4 Message-ID: Subject: Re: add function argument name to substring and substr To: PostgreSQL-development Content-Type: multipart/mixed; boundary="000000000000cadd3a062ca6b939" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cadd3a062ca6b939 Content-Type: text/plain; charset="UTF-8" hi. I forgot to attach the patch. here we are. --000000000000cadd3a062ca6b939 Content-Type: text/x-patch; charset="US-ASCII"; name="v1-0001-add-function-argument-name-to-function-substring-.patch" Content-Disposition: attachment; filename="v1-0001-add-function-argument-name-to-function-substring-.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_m6ef83sh0 RnJvbSAyNDlhMDgzNjI3YjBkOGFkMTVjNjk4NjAxZjdiNzY0OWJlNTI2MmExIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBqaWFuIGhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+ CkRhdGU6IFdlZCwgMjIgSmFuIDIwMjUgMTQ6MTk6MTUgKzA4MDAKU3ViamVjdDogW1BBVENIIHYx IDEvMV0gYWRkIGZ1bmN0aW9uIGFyZ3VtZW50IG5hbWUgdG8gZnVuY3Rpb24gc3Vic3RyaW5nIGFu ZAogc3Vic3RyCgotLS0KIHNyYy9iYWNrZW5kL2NhdGFsb2cvc3lzdGVtX2Z1bmN0aW9ucy5zcWwg fCAgMiArLQogc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wcm9jLmRhdCAgICAgICAgICB8IDEyICsr KysrKysrKysrKwogMiBmaWxlcyBjaGFuZ2VkLCAxMyBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9u KC0pCgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1fZnVuY3Rpb25zLnNx bCBiL3NyYy9iYWNrZW5kL2NhdGFsb2cvc3lzdGVtX2Z1bmN0aW9ucy5zcWwKaW5kZXggNTkxMTU3 YjFkMS4uMGZjMWQ5YTRhNSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1f ZnVuY3Rpb25zLnNxbAorKysgYi9zcmMvYmFja2VuZC9jYXRhbG9nL3N5c3RlbV9mdW5jdGlvbnMu c3FsCkBAIC00Miw3ICs0Miw3IEBAIENSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHJwYWQodGV4 dCwgaW50ZWdlcikKICBJTU1VVEFCTEUgUEFSQUxMRUwgU0FGRSBTVFJJQ1QgQ09TVCAxCiBSRVRV Uk4gcnBhZCgkMSwgJDIsICcgJyk7CiAKLUNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OICJzdWJz dHJpbmciKHRleHQsIHRleHQsIHRleHQpCitDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiAic3Vi c3RyaW5nIihzdHJpbmcgdGV4dCwgcGF0dGVybiB0ZXh0LCBlc2NhcGVfY2hhcmFjdGVyIHRleHQp CiAgUkVUVVJOUyB0ZXh0CiAgTEFOR1VBR0Ugc3FsCiAgSU1NVVRBQkxFIFBBUkFMTEVMIFNBRkUg U1RSSUNUIENPU1QgMQpkaWZmIC0tZ2l0IGEvc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wcm9jLmRh dCBiL3NyYy9pbmNsdWRlL2NhdGFsb2cvcGdfcHJvYy5kYXQKaW5kZXggMTg1NjA3NTVkMi4uYjJl YmNjYjViNiAxMDA2NDQKLS0tIGEvc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wcm9jLmRhdAorKysg Yi9zcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3Byb2MuZGF0CkBAIC0zNjM3LDYgKzM2MzcsNyBAQAog ICBwcm9zcmMgPT4gJ3J0cmltJyB9LAogeyBvaWQgPT4gJzg3NycsIGRlc2NyID0+ICdleHRyYWN0 IHBvcnRpb24gb2Ygc3RyaW5nJywKICAgcHJvbmFtZSA9PiAnc3Vic3RyJywgcHJvcmV0dHlwZSA9 PiAndGV4dCcsIHByb2FyZ3R5cGVzID0+ICd0ZXh0IGludDQgaW50NCcsCisgIHByb2FyZ25hbWVz ID0+ICd7c3RyaW5nLCBzdGFydCwgY291bnR9JywKICAgcHJvc3JjID0+ICd0ZXh0X3N1YnN0cicg fSwKIHsgb2lkID0+ICc4NzgnLCBkZXNjciA9PiAnbWFwIGEgc2V0IG9mIGNoYXJhY3RlcnMgYXBw ZWFyaW5nIGluIHN0cmluZycsCiAgIHByb25hbWUgPT4gJ3RyYW5zbGF0ZScsIHByb3JldHR5cGUg PT4gJ3RleHQnLCBwcm9hcmd0eXBlcyA9PiAndGV4dCB0ZXh0IHRleHQnLApAQCAtMzY1NSw2ICsz NjU2LDcgQEAKICAgcHJvc3JjID0+ICdydHJpbTEnIH0sCiB7IG9pZCA9PiAnODgzJywgZGVzY3Ig PT4gJ2V4dHJhY3QgcG9ydGlvbiBvZiBzdHJpbmcnLAogICBwcm9uYW1lID0+ICdzdWJzdHInLCBw cm9yZXR0eXBlID0+ICd0ZXh0JywgcHJvYXJndHlwZXMgPT4gJ3RleHQgaW50NCcsCisgIHByb2Fy Z25hbWVzID0+ICd7c3RyaW5nLCBzdGFydH0nLAogICBwcm9zcmMgPT4gJ3RleHRfc3Vic3RyX25v X2xlbicgfSwKIHsgb2lkID0+ICc4ODQnLCBkZXNjciA9PiAndHJpbSBzZWxlY3RlZCBjaGFyYWN0 ZXJzIGZyb20gYm90aCBlbmRzIG9mIHN0cmluZycsCiAgIHByb25hbWUgPT4gJ2J0cmltJywgcHJv cmV0dHlwZSA9PiAndGV4dCcsIHByb2FyZ3R5cGVzID0+ICd0ZXh0IHRleHQnLApAQCAtMzY2NSw5 ICszNjY3LDExIEBACiAKIHsgb2lkID0+ICc5MzYnLCBkZXNjciA9PiAnZXh0cmFjdCBwb3J0aW9u IG9mIHN0cmluZycsCiAgIHByb25hbWUgPT4gJ3N1YnN0cmluZycsIHByb3JldHR5cGUgPT4gJ3Rl eHQnLCBwcm9hcmd0eXBlcyA9PiAndGV4dCBpbnQ0IGludDQnLAorICBwcm9hcmduYW1lcyA9PiAn e3N0cmluZywgc3RhcnQsIGNvdW50fScsCiAgIHByb3NyYyA9PiAndGV4dF9zdWJzdHInIH0sCiB7 IG9pZCA9PiAnOTM3JywgZGVzY3IgPT4gJ2V4dHJhY3QgcG9ydGlvbiBvZiBzdHJpbmcnLAogICBw cm9uYW1lID0+ICdzdWJzdHJpbmcnLCBwcm9yZXR0eXBlID0+ICd0ZXh0JywgcHJvYXJndHlwZXMg PT4gJ3RleHQgaW50NCcsCisgIHByb2FyZ25hbWVzID0+ICd7c3RyaW5nLCBzdGFydH0nLAogICBw cm9zcmMgPT4gJ3RleHRfc3Vic3RyX25vX2xlbicgfSwKIHsgb2lkID0+ICcyMDg3JywKICAgZGVz Y3IgPT4gJ3JlcGxhY2UgYWxsIG9jY3VycmVuY2VzIGluIHN0cmluZyBvZiBvbGRfc3Vic3RyIHdp dGggbmV3X3N1YnN0cicsCkBAIC00MDg1LDYgKzQwODksNyBAQAogICBwcm9zcmMgPT4gJ2JpdGNh dCcgfSwKIHsgb2lkID0+ICcxNjgwJywgZGVzY3IgPT4gJ2V4dHJhY3QgcG9ydGlvbiBvZiBiaXRz dHJpbmcnLAogICBwcm9uYW1lID0+ICdzdWJzdHJpbmcnLCBwcm9yZXR0eXBlID0+ICdiaXQnLCBw cm9hcmd0eXBlcyA9PiAnYml0IGludDQgaW50NCcsCisgIHByb2FyZ25hbWVzID0+ICd7Yml0cywg c3RhcnQsIGNvdW50fScsCiAgIHByb3NyYyA9PiAnYml0c3Vic3RyJyB9LAogeyBvaWQgPT4gJzE2 ODEnLCBkZXNjciA9PiAnYml0c3RyaW5nIGxlbmd0aCcsCiAgIHByb25hbWUgPT4gJ2xlbmd0aCcs IHByb3JldHR5cGUgPT4gJ2ludDQnLCBwcm9hcmd0eXBlcyA9PiAnYml0JywKQEAgLTQxMTQsNiAr NDExOSw3IEBACiAgIHByb3NyYyA9PiAnYml0cG9zaXRpb24nIH0sCiB7IG9pZCA9PiAnMTY5OScs IGRlc2NyID0+ICdleHRyYWN0IHBvcnRpb24gb2YgYml0c3RyaW5nJywKICAgcHJvbmFtZSA9PiAn c3Vic3RyaW5nJywgcHJvcmV0dHlwZSA9PiAnYml0JywgcHJvYXJndHlwZXMgPT4gJ2JpdCBpbnQ0 JywKKyAgcHJvYXJnbmFtZXMgPT4gJ3tiaXRzLCBzdGFydH0nLAogICBwcm9zcmMgPT4gJ2JpdHN1 YnN0cl9ub19sZW4nIH0sCiAKIHsgb2lkID0+ICczMDMwJywgZGVzY3IgPT4gJ3N1YnN0aXR1dGUg cG9ydGlvbiBvZiBiaXRzdHJpbmcnLApAQCAtNjE4NSwxNSArNjE5MSwxOSBAQAogICBwcm9zcmMg PT4gJ2J5dGVhY2F0JyB9LAogeyBvaWQgPT4gJzIwMTInLCBkZXNjciA9PiAnZXh0cmFjdCBwb3J0 aW9uIG9mIHN0cmluZycsCiAgIHByb25hbWUgPT4gJ3N1YnN0cmluZycsIHByb3JldHR5cGUgPT4g J2J5dGVhJywKKyAgcHJvYXJnbmFtZXMgPT4gJ3tieXRlcywgc3RhcnQsIGNvdW50fScsCiAgIHBy b2FyZ3R5cGVzID0+ICdieXRlYSBpbnQ0IGludDQnLCBwcm9zcmMgPT4gJ2J5dGVhX3N1YnN0cicg fSwKIHsgb2lkID0+ICcyMDEzJywgZGVzY3IgPT4gJ2V4dHJhY3QgcG9ydGlvbiBvZiBzdHJpbmcn LAogICBwcm9uYW1lID0+ICdzdWJzdHJpbmcnLCBwcm9yZXR0eXBlID0+ICdieXRlYScsIHByb2Fy Z3R5cGVzID0+ICdieXRlYSBpbnQ0JywKKyAgcHJvYXJnbmFtZXMgPT4gJ3tieXRlcywgc3RhcnR9 JywKICAgcHJvc3JjID0+ICdieXRlYV9zdWJzdHJfbm9fbGVuJyB9LAogeyBvaWQgPT4gJzIwODUn LCBkZXNjciA9PiAnZXh0cmFjdCBwb3J0aW9uIG9mIHN0cmluZycsCiAgIHByb25hbWUgPT4gJ3N1 YnN0cicsIHByb3JldHR5cGUgPT4gJ2J5dGVhJywgcHJvYXJndHlwZXMgPT4gJ2J5dGVhIGludDQg aW50NCcsCisgIHByb2FyZ25hbWVzID0+ICd7Ynl0ZXMsIHN0YXJ0LCBjb3VudH0nLAogICBwcm9z cmMgPT4gJ2J5dGVhX3N1YnN0cicgfSwKIHsgb2lkID0+ICcyMDg2JywgZGVzY3IgPT4gJ2V4dHJh Y3QgcG9ydGlvbiBvZiBzdHJpbmcnLAogICBwcm9uYW1lID0+ICdzdWJzdHInLCBwcm9yZXR0eXBl ID0+ICdieXRlYScsIHByb2FyZ3R5cGVzID0+ICdieXRlYSBpbnQ0JywKKyAgcHJvYXJnbmFtZXMg PT4gJ3tieXRlcywgc3RhcnR9JywKICAgcHJvc3JjID0+ICdieXRlYV9zdWJzdHJfbm9fbGVuJyB9 LAogeyBvaWQgPT4gJzIwMTQnLCBkZXNjciA9PiAncG9zaXRpb24gb2Ygc3Vic3RyaW5nJywKICAg cHJvbmFtZSA9PiAncG9zaXRpb24nLCBwcm9yZXR0eXBlID0+ICdpbnQ0JywgcHJvYXJndHlwZXMg PT4gJ2J5dGVhIGJ5dGVhJywKQEAgLTYzODIsOSArNjM5MiwxMSBAQAogCiB7IG9pZCA9PiAnMjA3 MycsIGRlc2NyID0+ICdleHRyYWN0IHRleHQgbWF0Y2hpbmcgcmVndWxhciBleHByZXNzaW9uJywK ICAgcHJvbmFtZSA9PiAnc3Vic3RyaW5nJywgcHJvcmV0dHlwZSA9PiAndGV4dCcsIHByb2FyZ3R5 cGVzID0+ICd0ZXh0IHRleHQnLAorICBwcm9hcmduYW1lcyA9PiAne3N0cmluZywgcGF0dGVybn0n LAogICBwcm9zcmMgPT4gJ3RleHRyZWdleHN1YnN0cicgfSwKIHsgb2lkID0+ICcyMDc0JywgZGVz Y3IgPT4gJ2V4dHJhY3QgdGV4dCBtYXRjaGluZyBTUUwgcmVndWxhciBleHByZXNzaW9uJywKICAg cHJvbmFtZSA9PiAnc3Vic3RyaW5nJywgcHJvbGFuZyA9PiAnc3FsJywgcHJvcmV0dHlwZSA9PiAn dGV4dCcsCisgIHByb2FyZ25hbWVzID0+ICd7c3RyaW5nLCBwYXR0ZXJuLCBlc2NhcGVfY2hhcmFj dGVyfScsCiAgIHByb2FyZ3R5cGVzID0+ICd0ZXh0IHRleHQgdGV4dCcsIHByb3NyYyA9PiAnc2Vl IHN5c3RlbV9mdW5jdGlvbnMuc3FsJyB9LAogCiB7IG9pZCA9PiAnMjA3NScsIGRlc2NyID0+ICdj b252ZXJ0IGludDggdG8gYml0c3RyaW5nJywKLS0gCjIuMzQuMQoK --000000000000cadd3a062ca6b939--