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 1qy0o3-0057X1-Gi for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Nov 2023 02:18:07 +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 1qy0o2-005UBa-6C for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Nov 2023 02:18:06 +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 1qy0o1-005UBS-TG for pgsql-hackers@lists.postgresql.org; Wed, 01 Nov 2023 02:18:05 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qy0nz-003NUW-E0 for pgsql-hackers@lists.postgresql.org; Wed, 01 Nov 2023 02:18:04 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qy0ny-0005m2-S6 for pgsql-hackers@lists.postgresql.org; Wed, 01 Nov 2023 02:18:02 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qy0nx-007bsH-53 for pgsql-hackers@lists.postgresql.org; Wed, 01 Nov 2023 02:18:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: Extract numeric filed in JSONB more effectively To: pgsql-hackers@lists.postgresql.org From: Chapman Flack Cc: Andy Fan Date: Wed, 01 Nov 2023 02:17:24 +0000 User-Agent: pgcommitfest X-cfsender: chap In-Reply-To: References: Message-ID: <169880504467.94392.3769687331705514588.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk QWRkaW5nIHRoaXMgY29tbWVudCB2aWEgdGhlIENGIGFwcCBzbyBpdCBpc24ndCBsb3N0LCB3aGls ZSBhbiBpbXByb3Blcmx5LWludGVycHJldGVkLURLSU0taGVhZGVycyBpc3N1ZSBpcyBzdGlsbCBw cmV2ZW50aW5nIG1lIGZyb20gbWFpbGluZyBkaXJlY3RseSB0byAtaGFja2Vycy4NCg0KSXQgd2Fz IG15IHZpZXcgdGhhdCB0aGUgcGF0Y2ggd2FzIGdldHRpbmcgY2xvc2UgYnkgdGhlIGVuZCBvZiB0 aGUgbGFzdCBjb21taXRmZXN0LCBidXQgc3RpbGwgY29udGFpbmVkIGEgYml0IG9mIGEgbG9naWMg d2FydCBtYWRlIG5lY2Vzc2FyeSBieSBhIHF1ZXN0aW9uYWJsZSBjaG9pY2Ugb2YgZXJyb3IgbWVz c2FnZSB3b3JkaW5nLCBzdWNoIHRoYXQgaW4gbXkgdmlldyBpdCB3b3VsZCBiZSBiZXR0ZXIgdG8g ZGV0ZXJtaW5lIHdoZXRoZXIgYSBkaWZmZXJlbnQgZXJyb3IgbWVzc2FnZSB3b3VsZCBiZXR0ZXIg Y29uZm9ybSB0byBJU08gU1FMIGluIHRoZSBmaXJzdCBwbGFjZSwgYW5kIG9idmlhdGUgdGhlIG5l ZWQgZm9yIHRoZSBsb2dpYyB3YXJ0Lg0KDQpUaGVyZSBzZWVtZWQgdG8gYmUgc29tZSBwcm9ncmVz cyBwb3NzaWJsZSBvbiB0aGF0IHdoZW4gcGV0ZXJlIGhhZCB0aW1lIHRvIHdlaWdoIGluIG9uIHRo ZSBzdGFuZGFyZCBzaG9ydGx5IGFmdGVyIHRoZSBsYXN0IENGIGVuZGVkLg0KDQpTbywgaXQgd291 bGQgbm90IGhhdmUgYmVlbiBteSBjaG9pY2UgdG8gYXNzaWduIFJmQyBzdGF0dXMgYmVmb3JlIGdl dHRpbmcgdG8gYSByZXNvbHV0aW9uIG9uIHRoYXQuDQoNCkFsc28sIGl0IGlzIHBvc3NpYmxlIGZv ciBhIEpzb25iVmFsdWUgdG8gaG9sZCBhIHRpbWVzdGFtcCAoYXMgYSByZXN1bHQgb2YgYSBqc29u cGF0aCBldmFsdWF0aW9uLCBJIGRvbid0IHRoaW5rIHRoYXQgY2FuIGhhcHBlbiBhbnkgb3RoZXIg d2F5KSwgYW5kIGlmIHN1Y2ggYSBqc29ucGF0aCBldmFsdWF0aW9uIHdlcmUgdG8gYmUgdGhlIHNv dXJjZSBleHByZXNzaW9uIG9mIGEgY2FzdCB0byBTUUwgdGltZXN0YW1wLCB0aGF0IHNpdHVhdGlv biBzZWVtcyBleGFjdGx5IGFuYWxvZ291cyB0byB0aGUgb3RoZXIgc2l0dWF0aW9ucyBiZWluZyBv cHRpbWl6ZWQgaGVyZSBhbmQgd291bGQgcmVxdWlyZSBvbmx5IGEgZmV3IG1vcmUgbGluZXMgaW4g dGhlIGV4YWN0IHBhdHRlcm4gaGVyZSBpbnRyb2R1Y2VkLiBXaGlsZSB0aGF0IGNvdWxkIGJlIGNh bGxlZCBvdXQgb2Ygc2NvcGUgd2hlbiB0aGlzIHBhdGNoJ3MgdGl0bGUgcmVmZXJzIHRvICJudW1l cmljIGZpZWxkIiBzcGVjaWZpY2FsbHksIGl0IG1pZ2h0IGJlIHdvcnRoIGNvbnNpZGVyaW5nIGZv ciBjb21wbGV0ZW5lc3MuIFRoZSBwYXRjaCBkb2VzLCBhZnRlciBhbGwsIGhhbmRsZSBib29sZWFu IGFscmVhZHksIGFzIHdlbGwgYXMgbnVtZXJpYy4=