Re: Extract numeric filed in JSONB more effectively

Hi Jian:

> return PointerGetDatum(v->val.numeric);
> should be something like
> PG_RETURN_NUMERIC(v->val.numeric);
> ?
>

Thanks for this reminder, a new patch is attached. and commitfest
entry is added as well[1]. For recording purposes, I compared the
new operator with all the existing operators.

select 1 from tb where (a->'a')::numeric = 2; 30.56ms
select 1 from tb where (a->>'a')::numeric = 2; 29.43ms
select 1 from tb where (a(at)->'a') = 2; 14.80ms

[1] https://commitfest.postgresql.org/44/4476/

--
Best Regards
Andy Fan