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 1w8hWh-000nLg-0k for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Apr 2026 16:37:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w8hWd-00CaGt-2z for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Apr 2026 16:37: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 1w8hWd-00CaGl-1r for pgsql-hackers@lists.postgresql.org; Fri, 03 Apr 2026 16:37:40 +0000 Received: from mail-dy1-x132e.google.com ([2607:f8b0:4864:20::132e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w8hWb-00000000P2u-0i2A for pgsql-hackers@lists.postgresql.org; Fri, 03 Apr 2026 16:37:39 +0000 Received: by mail-dy1-x132e.google.com with SMTP id 5a478bee46e88-2cd339aeab4so143435eec.0 for ; Fri, 03 Apr 2026 09:37:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775234255; x=1775839055; darn=lists.postgresql.org; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=pvsYivHQcQBxN9tqD3nUCsrO/Ze1XlWihvmy1XU3Has=; b=qDr6o0BP+9vy7hhWSsbVVP7bWrWmD2bhr0tFN6O7Db5uMkhogrlc444QnpDWYl/250 odNTkUVFNpnlLLct1iwJ1SZb7NBjuXvNZuQv5ALABN1g73oawwxl2ISMDDLzGajK9WTQ dBZsJuDi+X2De6Ro25rShBut7KgUvUO8jo8MxsBuqO5szDao3ReClnhv8M/zGW+KKL9p NmhxM4BDoPOUBD7XBWJV3EHHTGUA5G0PE2qL6YEZ+5iu2VSJHfGM/vwT8FotaahVQMoG CMr/U7k8gGnPwiTtL636mwZ6nUhGNcFMg5GYq35dTO4plQAs7zNR9PzeNx0UJ/TVykKE 8xCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775234255; x=1775839055; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=pvsYivHQcQBxN9tqD3nUCsrO/Ze1XlWihvmy1XU3Has=; b=UyzCQOPrl1vd3l8aqyVY6QC7SdKiN7ghwdDl2l6LHWZswinDzShIPOVCkKXwnWKAdj WpElinm+Z8wcUWLGMuoiGJeAmtzQctY3TDn1fbv8LDHkjGnCNGkK5B0dmcjJfrVFTFm1 T1ENocluTvlWffLnAYgOhP7nHOHpFINIuljPPLD24Gmq6pOdBrnIDPKIE+tlPQksfgHM L1YkAUGBGrozlV5czr0Gwm3x1vjmYX0un7XDG38LyzUjEyeRzvt5/nN4iya7kRAAH1tV z3gA14TniLmT3l/vpTDZ8VSkr6JSgifJHdxmixqalbRswEjr1aajDYZrrwuzQGilMp44 QTvg== X-Forwarded-Encrypted: i=1; AJvYcCWNPptY0CG//odzXMPGKeThnem/n3jn+Vs+tN2fRS375k9uOdfB9ozHyYrhFnAATE8WZ+IfM0GBDgceoM1e@lists.postgresql.org X-Gm-Message-State: AOJu0Yx8dgsrGsKlCAp0FbzA00NLVQChzwASyZBOe9sW89IqF0kskMvs TcQS/cP7O2ZBkbs/KJGgyYVIcDWio7Byaw+IhxO8jjDiARUD1WmgtnjJ X-Gm-Gg: AeBDieufhtmNKFWQrQVj3426VzIK1q4DHeUWR/RD/hwMdWe20qMCKP1Ik/LLdVco1Ra i1L995p7b7JR/LVblPIfxhi2AG0mAD0ybfhKWrcP/8Cbyj4SwyO3eh0WCXo39JLGsUjE2d4JR2Y KF4BED7h+DXADA4zWIR2oiBzY39YOzTdZ677Pxv0dQLWNlqw7TCwgR/9b7EuwxON9e89Yhsfpku mjCN3uvuGtZaeZDOPKlhpvgBOeVLq6GQwtgH2K+Wxy6MJn//K25CMeHJVX81ZsPdkdHq2AAuu+d 0zgkeEKs6Ey9IvGWvzIis75RwiLfPI/9AIIXOt92GIwtfs79mAotkJf8Gu6DmCwS3NrkM8W1/Wn AnpraY9VlTI6JY9Cn2Z4fWgdJKSqGNi/tLi0QXyUiOLiFjWOm1hve7dXMlVOzp/diOgSl/N/Dyx 0JJvbPyZ1e/lEK2cVOiyLe6JW+xj+othRxeIQcLQj4C+w7rI+9WBB4I6IadjbRTg== X-Received: by 2002:a05:7300:6da5:b0:2c6:7f49:a86c with SMTP id 5a478bee46e88-2cbfada2460mr2056068eec.15.1775234254568; Fri, 03 Apr 2026 09:37:34 -0700 (PDT) Received: from smtpclient.apple ([2620:149:13d0::c50]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2ca7c3010e9sm7561604eec.14.2026.04.03.09.37.33 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 03 Apr 2026 09:37:34 -0700 (PDT) From: Haibo Yan X-Google-Original-From: Haibo Yan Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_FDAC9B75-7980-4FEA-AC5D-BC2C8710DC58" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.500.181\)) Subject: Re: Extract numeric filed in JSONB more effectively Date: Fri, 3 Apr 2026 09:37:22 -0700 In-Reply-To: Cc: Dmitry Dolgov <9erthalion6@gmail.com>, Andy Fan , Peter Eisentraut , Amit Langote , Alvaro Herrera , jian he , Chapman Flack , pgsql-hackers@lists.postgresql.org To: David Rowley 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> X-Mailer: Apple Mail (2.3864.500.181) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_FDAC9B75-7980-4FEA-AC5D-BC2C8710DC58 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 On Apr 2, 2026, at 11:41=E2=80=AFPM, David Rowley = wrote: >=20 > On Fri, 3 Apr 2026 at 17:46, Haibo Yan > wrote: >> I=E2=80=99d like to continue pushing this patch forward. >=20 > Please can you add it to the PG20-1 commitfest @ [1]. >=20 > David >=20 > [1] https://commitfest.postgresql.org/59/ Done =E2=80=94 I=E2=80=99ve added it to the PG20-1 CommitFest: https://commitfest.postgresql.org/patch/6644/ Thanks for the reminder. Regards, Haibo= --Apple-Mail=_FDAC9B75-7980-4FEA-AC5D-BC2C8710DC58 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 On Apr 2, 2026, at 11:41=E2=80=AFPM, = David Rowley <dgrowleyml@gmail.com> wrote:

On Fri, = 3 Apr 2026 at 17:46, Haibo Yan <tristan.yim@gmail.com> 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/
Done =E2=80=94 I=E2=80=99ve added it to the PG20-1 = CommitFest:

https://commitfest.postgresql.org/patch/6644/

Thanks for the reminder.

Regards,

Haibo

= --Apple-Mail=_FDAC9B75-7980-4FEA-AC5D-BC2C8710DC58--