Re: Jsonb gets extra quotes when returned from a function that break json format - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Jsonb gets extra quotes when returned from a function that break json format
Date
Msg-id CAKFQuwY4KtiCrFK5C3uWedpqZ_VnjSXLYfBaVOVoR+wqie2aPg@mail.gmail.com
Whole thread Raw
In response to Jsonb gets extra quotes when returned from a function that break json format  (Jakub Palenik <jakub.palenik@biosort.no>)
List 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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17028: Publish PGP Keys on 3rd party domains (enable out-of-band verifications)
Next
From: Pavel Stehule
Date:
Subject: Re: Jsonb gets extra quotes when returned from a function that break json format