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 1rMNYM-004HqB-46 for pgsql-hackers@arkaria.postgresql.org; Sun, 07 Jan 2024 07:26:38 +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 1rMNYJ-00EK2e-U2 for pgsql-hackers@arkaria.postgresql.org; Sun, 07 Jan 2024 07:26:35 +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.94.2) (envelope-from ) id 1rMNYJ-00EK2W-Jb for pgsql-hackers@lists.postgresql.org; Sun, 07 Jan 2024 07:26:35 +0000 Received: from m15.mail.163.com ([45.254.50.220]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rMNY9-000ICl-9J for pgsql-hackers@lists.postgresql.org; Sun, 07 Jan 2024 07:26:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=From:Subject:Date:Message-ID:MIME-Version: Content-Type; bh=ees5YiSwsF53Y98f9XNmjdry0T2viox40+HjMCxfd0I=; b=MAIeYQoVMdMewwLwok07pSFMgv6HpwvSk9jZxIunoKdtVFR0oTvSIXsjblKWhQ fRl9p6z3m5avKpEbYs0hCAF51oQwU+8gWWLYaQWw06Rx1ZWbLR4AY/2E/1JDGs3M XvYLv1eUk9NiSjgnnyH4oyqFfUTOIS+GaLk0cUJhV757o= Received: from b97369165980 (unknown [140.205.118.23]) by zwqz-smtp-mta-g0-1 (Coremail) with SMTP id _____wC3T3XqUZpl3+jfAg--.22912S3; Sun, 07 Jan 2024 15:25:31 +0800 (CST) References: <169880504467.94392.3769687331705514588.pgcf@coridan.postgresql.org> <87a5rry0bz.fsf@163.com> User-agent: mu4e 1.10.7; emacs 29.1 From: Andy Fan To: jian he Cc: Chapman Flack , pgsql-hackers@lists.postgresql.org Subject: Re: Extract numeric filed in JSONB more effectively Date: Sun, 07 Jan 2024 15:17:16 +0800 In-reply-to: Message-ID: <87h6jpob9x.fsf@163.com> MIME-Version: 1.0 Content-Type: text/plain X-CM-TRANSID:_____wC3T3XqUZpl3+jfAg--.22912S3 X-Coremail-Antispam: 1Uf129KBjvdXoW7XrWxGFyxZFWDCryDWw17Jrb_yoWDGFX_Ga 4UZas7CFs5XFnFyw45tw1rZryUCa1rJrWYkF18Ga4DGr9Fqr40g340gFy5Xa4qyFWUtwsx Cw4kX39rKw13ujkaLaAFLSUrUUUUjb8apTn2vfkv8UJUUUU8Yxn0WfASr-VFAUDa7-sFnT 9fnUUvcSsGvfC2KfnxnUUI43ZEXa7xR_ksg5UUUUU== X-Originating-IP: [140.205.118.23] X-CM-SenderInfo: x2klx3xlid0iqsrtqiywtou0bp/1tbiQA9eU2VOA4o+7wAAsx List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, > hi. > you don't need to change src/include/catalog/catversion.h > as mentioned in https://wiki.postgresql.org/wiki/Committing_checklist > Otherwise, cfbot will fail many times. Thanks for the wiki. I checked the wiki and search "catversion", the only message I got is: "Consider the need for a catversion bump." How could this be explained as "no need to change ../catversion.h"? > > +typedef enum JsonbValueTarget > +{ > + JsonbValue_AsJsonbValue, > + JsonbValue_AsJsonb, > + JsonbValue_AsText > +} JsonbValueTarget; > > change to > > +typedef enum JsonbValueTarget > +{ > + JsonbValue_AsJsonbValue, > + JsonbValue_AsJsonb, > + JsonbValue_AsText, > +} JsonbValueTarget; > > currently cannot do `git apply`. OK, I guess it's something about whitespaces, my git-commit hook has been configured to capture this during commit. After we reach an agreement about the 'catversion.h' stuff, the next version of patch should fix this issue. -- Best Regards Andy Fan