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@->'a') = 2;              14.80ms 

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

--

Best Regards

Andy Fan