Re: Jsonb gets extra quotes when returned from a function that break json format

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Jsonb gets extra quotes when returned from a function that break json format
Дата
Msg-id CAKFQuwY4KtiCrFK5C3uWedpqZ_VnjSXLYfBaVOVoR+wqie2aPg@mail.gmail.com
обсуждение исходный текст
Ответ на Jsonb gets extra quotes when returned from a function that break json format  (Jakub Palenik <jakub.palenik@biosort.no>)
Список pgsql-bugs
Дерево обсуждения
On Wed, May 19, 2021 at 8:04 AM Jakub Palenik <jakub.palenik@biosort.no> wrote:
Greetings,
I am using postgres database running within docker v13.3 (latest). I have found an issue where jsonb and timestamp type returned from function saved in the db assumes extra quotes and thus break json format.

You are printing a tuple which has a json column.  The tuple has its own escaping/quoting rules as does json.  You are seeing the combination of both.

You cannot do anything with the json value unless you first extract it from the tuple so while I get the confusion about the visual and you experiencing any actual issues because of this?

David J.


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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17028: Publish PGP Keys on 3rd party domains (enable out-of-band verifications)
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Jsonb gets extra quotes when returned from a function that break json format