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 1w8hbQ-000nPh-2t for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Apr 2026 16:42:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w8hbP-00CcNu-2C for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Apr 2026 16:42:36 +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 1w8hbP-00CcNl-1H for pgsql-hackers@lists.postgresql.org; Fri, 03 Apr 2026 16:42:35 +0000 Received: from mail-dy1-x1331.google.com ([2607:f8b0:4864:20::1331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w8hbN-00000000Nmb-1rCX for pgsql-hackers@lists.postgresql.org; Fri, 03 Apr 2026 16:42:34 +0000 Received: by mail-dy1-x1331.google.com with SMTP id 5a478bee46e88-2c7d8bbad06so4835654eec.1 for ; Fri, 03 Apr 2026 09:42:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775234552; x=1775839352; 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=VruM1+TMM8Lz9+6nZ/0KQqpCVhm5tAXGw6DSb4fH9rs=; b=rnwBZB0nwXTID95l6Dnf+Mg3tmEPF6qkXVFh8FRCsdp+di9zHPXL68RElNiTQ6Zsd3 n+5EkqTBp+k7iGNx9Z7vX0Qz2aSBkqqPaifKcmldbVKkUJo7K4PnmdO6OZQ5M7CIz7gD p0jCIO2byrs2fRfUgEeRQi/UERjaxlXFnvYpvB4jd+eg+3P1KRn9sRA7XCLcA57UacJ4 iM1D1RDO5ih45PgwXvyKyaIDaTiYxtPeCxXE0TDeu5LEk2+ENvybwqHv69dAMfiGF5ok A6PHcpDB++h7sYCKMKajbYdRash7mB6OGF5vLeitNASO9Nt3vSo+EzD+HO+Hv0zZ0PYT h0pg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775234552; x=1775839352; 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=VruM1+TMM8Lz9+6nZ/0KQqpCVhm5tAXGw6DSb4fH9rs=; b=AU7qmGIDindN5rm9/HUDZ13pNGRxABYCK8HsC5AZ+y2IKB6FAj0DFb8nZGmU7ytTc5 GjWMzWk2zyjixuUvTlZA07cCpcbm+rh0eHvqn1D5PueKZ4avB+SKnSobUBLaGiYD7qYa ZVKiqR4a8R6NfgEhwCfBXTiaEUbIja4DQQ/74RRt6Kw6OFffOz/ZzD2+MnKFk1HBADO5 CYAoJVG/lzUvN3Z+bx2gnpbroe3yVZ+tRkmOuACRiSpEa9wpK2Goxrbc8/fjKVv6jg9h 558q1aIaoz1pmthltSXKi63snuoqR2k+GUtNl+TpXKfYRGFoNWUZArAahtYSGg47++tv X6dA== X-Forwarded-Encrypted: i=1; AJvYcCUpgXRyABifeTHgQfgI8ZW8twpOUINPMwOk+C+Ce7BAPeebRwZWM7OUaXcSD1KqS7BscLFGKAGVA/lD78BG@lists.postgresql.org X-Gm-Message-State: AOJu0YwRW8G6KQkRhujwlIE3wGCnatMhC1ksGBde2xr47tK64awjm2rx uSgp2cEwtHR9CTg+mKywkit18HiGDUuVbYg7iHbNmiLlH1IcAOAtH9RC X-Gm-Gg: AeBDiet8CaPd06Fu3Iu0Q3arw8vs38CGMqBH2tnP0ppFKU1hl628QUbEyb0bdPpP7vk 60mOM6rweDC2JLc+EqLy7AihFDtz2qsYvojx/zNpaejfRKRu69E+0BWjPaYNVv3TTHDmeub3/4s ApvTMaa8f5TUvCKVGBhguS4ms1U2ZNXIONzl4k+dBIJXRyx17MumcqwXLUbZ/n93otdcPiaG/Co vUF4knhADyK6XYLE77BZL483Zhq7H+n2MbuqrP4o5jzkvF0h4gf7vPCzKG276XitXLwAzZjOm25 wbayccabrd875EH8HgMbolrJ6MFyeuEeDBYu+L3G2Ju93VETSKhzbfDBoUuIj/7U9+ey//XxQsC qZlheb16vgdOb8XnpBnOoznzuzI6tBCleSuJ3nl3x4O8zNvMqeDrY3VN05HoVWbReuDy1IAgP6X OA6YyPP/tYSz5SSlrBVDeUPRDrmLxPkTlxbSLslP9U+yKqE6mR9KCdy+xfLT0jcw== X-Received: by 2002:a05:7300:371f:b0:2c5:76d1:7f95 with SMTP id 5a478bee46e88-2cbfc763331mr1853050eec.28.1775234551774; Fri, 03 Apr 2026 09:42:31 -0700 (PDT) Received: from smtpclient.apple ([2620:149:13d0::c50]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2cafd073194sm4554050eec.28.2026.04.03.09.42.30 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 03 Apr 2026 09:42:31 -0700 (PDT) From: Haibo Yan X-Google-Original-From: Haibo Yan Message-Id: <40442A5A-C7BF-4742-9F88-1068686EC174@gmail.com> Content-Type: multipart/alternative; boundary="Apple-Mail=_71F894C6-D3B1-4E9A-A9C6-235899F4D5AF" 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:42:20 -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=_71F894C6-D3B1-4E9A-A9C6-235899F4D5AF 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/ Hi David, Done =E2=80=94 I=E2=80=99ve added it to the PG20-1 CommitFest: https://commitfest.postgresql.org/patch/6644/ One small thing: the UI looks a bit odd on my side. It does not seem to = have picked my attachment, and is instead showing your older attachment = there. But cfbot appears to have picked up mine, so I think it may just = be a UI issue. Thanks for the reminder. Regards, Haibo= --Apple-Mail=_71F894C6-D3B1-4E9A-A9C6-235899F4D5AF 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/
Hi David,

Done =E2=80=94 I=E2=80=99ve = added it to the PG20-1 CommitFest:

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

One small thing: the UI looks a bit odd on my side. It does = not seem to have picked my attachment, and is instead showing your older = attachment there. But cfbot appears to have picked up mine, so I think = it may just be a UI issue.

Thanks for the = reminder.

Regards,

Haibo

= --Apple-Mail=_71F894C6-D3B1-4E9A-A9C6-235899F4D5AF--