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 1w8YDv-000eDl-2b for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Apr 2026 06:41:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w8YDs-00A2LG-1j for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Apr 2026 06:41:40 +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 1w8YDs-00A2L7-0Y for pgsql-hackers@lists.postgresql.org; Fri, 03 Apr 2026 06:41:40 +0000 Received: from mail-wr1-x432.google.com ([2a00:1450:4864:20::432]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w8YDp-00000000KXU-2Gj6 for pgsql-hackers@lists.postgresql.org; Fri, 03 Apr 2026 06:41:40 +0000 Received: by mail-wr1-x432.google.com with SMTP id ffacd0b85a97d-43cf8fe9c2aso872728f8f.2 for ; Thu, 02 Apr 2026 23:41:37 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775198496; cv=none; d=google.com; s=arc-20240605; b=Mamqs3j0HtCa/HRtmNpZ+iP9pOUG6FsM06mJ2Mu+FIGD6KDlxnFgw6fcnwhP+g1+ia kNn1xb+JLPr1kqv/Upk/sJzeK8SINjB5ybu1svHnoZUb7dCnXZJe7E0e0H9GNhx1Fzn+ qLIRJK33Ex08sui3gmOD39deOO2dH7Es2TDzXzJT2DkAUa1lVjWE9IBvE2PQoIjlKziy SxW0yJLKcXl6+odSu7ZVS7nzdwPxY/zcAePcIgI1fvuGpUPYwz8ZIASvirzrdUUSewEr UkvfzQ76PpOQy6dPxd0STLAwIIc2cU+FVkIT1TtUvvZbtNKyNcP+aMj8ciNFJzlNUgJg Zmkw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=nJ0P1dks+K8k8tiMNNgqYDUdZyABM0MR31QPTjBl8/4=; fh=okg0TXZstWLnHSCyW+8qUtCFu9NJZyFJVlX9+2GWm2E=; b=K0AmnuJbIko7d2J47UKnR55EDV4aaRTjrQu1zG4TGx7E3CjBzoMPzOoyqO+L0gW+7t MOBl7a0NDQJ/kcZli6W3/rdxYxLbVcwdP6fY2v/m6grPaqRlQsckUv5eKSXwd6H31iAP qxyZsONH9A1p4Pgj2cKEVmaC6iFq9DsY2xcKZc2GBSYdBu8WWt1vD39dxaRMIqKi1Mtx hvE3sP3WHpKBXTFisFVOcx5uV8B5saYvNXGZDvNE9QKBHqjEVyo6hyeiSeV5TvrZ8y3M oN1xUtsBrAVVqfb98k3IOgDDHP7V6HJG8W7HKHjLXit3C0bCukmRR9NTzym/lVxO7DYZ xrqg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775198496; x=1775803296; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=nJ0P1dks+K8k8tiMNNgqYDUdZyABM0MR31QPTjBl8/4=; b=QiOfOPYwIpvj39/Jazg9A5YOOz5HpHBW7Ndm5Z23yeI/iosO3PW18/HS6lbfVL4O6a iG3CXpMi4bKqoWssX3xRE5pTldnPFu+4jfpeddlR8QgAojtiOqBrQESK2NKlWSfCsv+p IjQQJeeD2DN/O8OpbzZKez4sInGeNh8b26zvkuz1VUsQ7QXcnGpnHVle7w/w/6YF4kzy yyuuIgQeH7D4xyJc0+yd2MuogCJ3ZXY1fUyKAO4rQlIFrX3CeKjehMrSbQZeIWdD4Vwr 04wOuKC2w7cJ+pM/e9GnIxfAJs7zHOAxb92JT85NJwz3gy+ST8nVGIYg2NpQ7kGgN8f4 pRQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775198496; x=1775803296; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=nJ0P1dks+K8k8tiMNNgqYDUdZyABM0MR31QPTjBl8/4=; b=gSpl3rEReCu+gH7UoWK/DM1+/uA/OaG0AliOkio98CX9hZh1MrFsUirDD5QEJ3Rtpe w/4S0vvF0/SgNhP4W6B5q59pVtqEfC6H6EUKfr65J7E0jjxXuxxN/C2DdNE0aH8GCXzE nh713ZHZe6DAHWw8xnNgsvRdBsGqnQaQL1cwPjhhcTJD4E0EyjFWy19cO7XsvB/foVaL GqHMZKBNNBzNxGDAcVLMYOxC+EdAJmjEfvUBq0Py3BONWY9FRreDM0bTwb0y17FUe+08 1W1YDUUWiVyCZU+e3vB701KxnOzod0ptBCiHE5C9B+l4MaoKV86oPtc4VfNh/Sg5OXwZ D8dw== X-Forwarded-Encrypted: i=1; AJvYcCWadw2CmMRAPljKtjmolTF59GbrhRW+PZJjwFHyiUHMnoGu0UGrXDxIMCeqTuPq3geU+jY6hqyzjKX4kTha@lists.postgresql.org X-Gm-Message-State: AOJu0YxeC03hHSo/CSNvCP0jGqCS1K616Yw/rCl1DhFc7WL0AusWeBm/ 8TunxY04ZI30/rhm5t5lKAjj7lZ73Re8CHUbQL7+X37NkmgyRrcdIGB/m/irNNF5/h98PfUc2L2 Ua7dYDtQIfcu05Kkfj2FzxKq1t8Wb6Qg= X-Gm-Gg: AeBDiesKF1Z9HhjqsMuaT1fn0BYk6gowItQASS90BXOxZWtCmAPlyrcg3ZM0LR/olJN KWz6JUcWUd76r+y+KOJJ08GM4gKuMv0KweYd8DE4pa3Cj1A3boohiGvkRrkDibkjmZ2Bjpytyu1 iZ4ukEX3Zm06fAMeJyXwoRYSUdha5Wo9IcHjXaSePY9dYP14QRCh3w5LsAhH9w23rafJObTMM2G bVVnjDfoBJfp5M45tdr58/pSvTHTS5hHGhwoZgbWdXAxIbzC+Htg7lnMRPl9clwoXP+jrSMs2kT nPGUGSC+Gla3rfmbS1DoKvwy6RiYm/hdwoCx3spGgYJlksuZG1eN3la5Chu9tsTw+/xsvknKwg= = X-Received: by 2002:a05:6000:4010:b0:43d:1e97:d62e with SMTP id ffacd0b85a97d-43d292e4100mr2850668f8f.24.1775198495497; Thu, 02 Apr 2026 23:41:35 -0700 (PDT) MIME-Version: 1.0 References: <87r0hmvuvr.fsf@163.com> <8102ff5b-b156-409e-a48f-e53e63a39b36@eisentraut.org> <8734t6c5rh.fsf@163.com> <87o7bn7z56.fsf@163.com> <875xx197bp.fsf@163.com> <87ttk0lgcx.fsf@163.com> <8734m5fua1.fsf@163.com> <87a5dx4cfb.fsf@163.com> <7487A577-7BDC-4B94-9FFA-741E95439BFC@gmail.com> In-Reply-To: <7487A577-7BDC-4B94-9FFA-741E95439BFC@gmail.com> From: David Rowley Date: Fri, 3 Apr 2026 19:41:21 +1300 X-Gm-Features: AQROBzDl7pnidy6YRTzHepGoNP230mFBiig-qrQX_Ig4RsvPPpgu0CSDh61auzQ Message-ID: Subject: Re: Extract numeric filed in JSONB more effectively To: Haibo Yan Cc: Dmitry Dolgov <9erthalion6@gmail.com>, Andy Fan , Peter Eisentraut , Amit Langote , Alvaro Herrera , jian he , Chapman Flack , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 3 Apr 2026 at 17:46, Haibo Yan wrote: > I=E2=80=99d like to continue pushing this patch forward. Please can you add it to the PG20-1 commitfest @ [1]. David [1] https://commitfest.postgresql.org/59/