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

Is there a reason not to transform the _tz flavors of
jsonb_path_query and jsonb_path-query_first?

I misunderstood the _tz flavors return timestamp,  after some deep

reading of these functions, they just work at the comparisons part.

so I will add them in the following version.  

try to apply jsonb extraction optimization to  _tz functions.

both jsonb_path_query_tz and jsonb_path_query_tz_first returns
the elements which are timestamp comparable, but such elements

are impossible to be cast to numeric or boolean IIUC. Just provides