Re: Extract numeric [field] in JSONB more effectively

Поиск
Список
Период
Сортировка
От Andy Fan
Тема Re: Extract numeric [field] in JSONB more effectively
Дата
Msg-id CAKU4AWpVbUSgq74ACqprLL+tF+UqOU19F59k-9ZX8rSBcH=sxw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Extract numeric [field] in JSONB more effectively  (Chapman Flack <chap@anastigmatix.net>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Laetitia Avrot
Дата:
Сообщение: Re: Adding a pg_servername() function
Следующее
От: Richard Guo
Дата:
Сообщение: Re: Fix last unitialized memory warning