Home > mailing lists

Re: Extract numeric filed in JSONB more effectively - Mailing list pgsql-hackers

From	Andy Fan
Subject	Re: Extract numeric filed in JSONB more effectively
Date	August 4, 2023 06:55:07
Msg-id	CAKU4AWrvguHRmjgSbSvmsBFeBAZdyXNNE94SnBYkYEmFF-KbYA@mail.gmail.com Whole thread Raw
In response to	Re: Extract numeric filed in JSONB more effectively (jian he <jian.universality@gmail.com>)
Responses	Re: Extract numeric filed in JSONB more effectively
List	pgsql-hackers

Hi:

can confirm the patch's jsonb_object_field_numeric is faster than
pg_catalog."numeric"(jsonb).

Thanks for the confirmation.

This function is not easy to find out...

select jsonb_numeric(jsonb'{"a":11}'->'a'); --fail

jsonb_numeric is a prosrc rather than a proname, that's why you

can't call them directly.

select * from pg_proc where prosrc = 'jsonb_numeric';
select * from pg_proc where proname = 'jsonb_numeric';

It is bound to "numeric"(jsonb) cast, so we can call it with

a->'a'::numeric.

select numeric('{"a":11}'->'a'); --fail.

select "numeric"('{"a":11}'::jsonb->'a'); --ok

The double quotes look weird to me. but it looks like a common situation.

select numeric('1'::int); -- failed.
select "numeric"('1'::int); -- ok.

Best Regards

Andy Fan

From: Pavel Stehule
Date: 04 August 2023, 06:54:15
Subject: Re: Extract numeric filed in JSONB more effectively

From: Yugo NAGATA
Date: 04 August 2023, 07:03:25
Subject: pgbench: allow to exit immediately when any client is aborted