Re: jsonb_object() seems to be buggy. jsonb_build_object() is good.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: jsonb_object() seems to be buggy. jsonb_build_object() is good.
Дата
Msg-id CAKFQuwa97NgrVKPdLZMKAffZyit-bZ+YrdhwTUMz3im8Spmi5w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: jsonb_object() seems to be buggy. jsonb_build_object() is good.  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-hackers
Дерево обсуждения
On Friday, February 14, 2020, Bryn Llewellyn <bryn@yugabyte.com> wrote:
The doc (“Builds a JSON object out of a text array.”) is simply too terse to inform an answer to this question.

It does presume knowledge but it precisely defines the outcome:

PostgreSQL arrays are typed and all members are of the same type.  A text array’s members are all text.

Given the above knowledge the fact that the resultant json object contains exclusively text keys and text values directly follows.

David J.

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

Предыдущее
От: Vik Fearing
Дата:
Сообщение: Re: jsonb_object() seems to be buggy. jsonb_build_object() is good.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: jsonb_object() seems to be buggy. jsonb_build_object() is good.