Re: [HACKERS] SQL/JSON in PostgreSQL

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] SQL/JSON in PostgreSQL
Дата
Msg-id CAFj8pRChOWNezywNeZhe9xtN=pOKc1ANDxPAH13Jum-eDeXtzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] SQL/JSON in PostgreSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: [HACKERS] SQL/JSON in PostgreSQL
Список pgsql-hackers
Hi

I am checking the JSONPath related code

Questions, notes:

1. jsonpath operators are not consistent with any other .. json, xml .. I am missing ?, @> operátors
2. documentation issue - there is "'{"a":[1,2,3,4,5]}'::json *? '$.a[*] ? (@ > 2)'" - operator *? doesn't exists
3. operator @~ looks like too aggressive shortcut - should be better commented

What is not clean, if jsonpath should to create some new operators for json, jsonb types? It is special filter, defined by type, so from my perspective the special operators are not necessary.

Regards

Pavel


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: January CommitFest is underway!
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Creating backup history files for backups taken from standbys