From: Andy Fan <zhihuifan1213@163.com>
To: Haibo Yan <tristan.yim@gmail.com>
Cc: Dmitry Dolgov <9erthalion6@gmail.com>,  David Rowley
 <dgrowleyml@gmail.com>,  Peter Eisentraut <peter@eisentraut.org>,  Amit
 Langote <amitlangote09@gmail.com>,  Alvaro Herrera
 <alvherre@alvh.no-ip.org>,  jian he <jian.universality@gmail.com>,
  Chapman Flack <chap@anastigmatix.net>,
  pgsql-hackers@lists.postgresql.org
Subject: Re: Extract numeric filed in JSONB more effectively
In-Reply-To: 
 <CABXr29GhnWxrGXD2YijYSDxwObGLqOsf8gvfzrFu=UcYU71XYA@mail.gmail.com>
	(Haibo Yan's message of "Tue, 7 Apr 2026 01:31:16 -0700")
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>
	<CAApHDvqnUONCN54dAXdH678ELK7aH2gyVhh0GjTRtrexPd9YMw@mail.gmail.com>
	<8734m5fua1.fsf@163.com>
	<mmilfltxeqgajpi4zok2v2moudot6bhdmwsqgjgnymz3nvkvng@k3caignaldcp>
	<87a5dx4cfb.fsf@163.com>
	<cudr6wao4hz2otlycx2z2equkigbjxslxvzqb3ejfc4amroheo@frqbvffcgqnu>
	<7487A577-7BDC-4B94-9FFA-741E95439BFC@gmail.com>
	<873417fgc0.fsf@163.com>
	<CABXr29GhnWxrGXD2YijYSDxwObGLqOsf8gvfzrFu=UcYU71XYA@mail.gmail.com>
User-Agent: mu4e 1.14.0-pre2; emacs 30.2
Date: Wed, 08 Apr 2026 07:59:26 +0800
Message-ID: <87eckqz5i9.fsf@163.com>
MIME-Version: 1.0
Content-Type: text/plain
Archived-At: <https://www.postgresql.org/message-id/87eckqz5i9.fsf%40163.com>
Precedence: bulk

Haibo Yan <tristan.yim@gmail.com> writes:

Hi Haibo,

> I agree that if this approach is extended to the full matrix naively,
> duplication will become a real issue.

Could you summary how it would be? I think it would be helpful for
others to review.  Otherwise every reviewer needs to count them many
times. 

-- 
Best Regards
Andy Fan