Re: Extract numeric [field] in JSONB more effectively - Mailing list pgsql-hackers

From Andy Fan
Subject Re: Extract numeric [field] in JSONB more effectively
Date
Msg-id CAKU4AWpVbUSgq74ACqprLL+tF+UqOU19F59k-9ZX8rSBcH=sxw@mail.gmail.com
Whole thread Raw
In response to Re: Extract numeric [field] in JSONB more effectively  (Chapman Flack <chap@anastigmatix.net>)
List pgsql-hackers
Hi Chap:
 
  Thanks for the review. 
 
The minor spelling point, the word 'field' has been spelled
'filed' throughout this comment (just as in the email subject):

+               /*
+                * Simplify cast(jsonb_object_filed(jsonb, filedName) as type)
+                * to jsonb_object_field_type(jsonb, filedName, targetTypeOid);
+                */

 
Thanks for catching this, fixed in v5. 
 
The question: the simplification is currently being applied
when the underlying operation uses F_JSONB_OBJECT_FIELD.
Are there opportunities for a similar benefit if applied
over F_JSONB_ARRAY_ELEMENT and/or F_JSONB_EXTRACT_PATH?

Yes, we do have similar opportunities for both functions.  v5 attached for this.    

--
Best Regards
Andy Fan
Attachment

pgsql-hackers by date:

Previous
From: Laetitia Avrot
Date:
Subject: Re: Adding a pg_servername() function
Next
From: Richard Guo
Date:
Subject: Re: Fix last unitialized memory warning