Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)
Дата
Msg-id CAFj8pRCx5j6GHm5SucKy9dVjNm20BnOJdHoft5cTf-kUgkajQA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения


2016-07-06 5:17 GMT+02:00 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:
On 7/2/16 12:40 AM, Pavel Stehule wrote:
So ANSI SQL conform implementation of JSON support is still possible in
Postgres.

 It is possible, but in this case I think it's not worth it.  Our built-in stuff is significantly simpler and more powerful and already in widespread use.

I can't to agree. JSONPath is little bit powerful than our JSON path expression. JSON_TABLE is pretty good function for extracting values from JSON (note: I missing XML_TABLE too much).

More - Postgres is not famous due not respecting standard.

Regards

Pavel

 

It is worth keeping an eye on it and not create gratuitous conflicts.


--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: can we optimize STACK_DEPTH_SLOP
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Password identifiers, protocol aging and SCRAM protocol