sql/json miscellaneous issue - Mailing list pgsql-hackers

From jian he
Subject sql/json miscellaneous issue
Date
Msg-id CACJufxEHgu8OWwm_+AXi1x9Kw4kjSX9wVLet2vTpGt76Q4Sf-w@mail.gmail.com
Whole thread Raw
Responses Re: sql/json miscellaneous issue
Re: sql/json miscellaneous issue
List pgsql-hackers
hi.
the following two queries should return the same result?

SELECT * FROM JSON_query (jsonb 'null', '$' returning jsonb);
SELECT * FROM JSON_value (jsonb 'null', '$' returning jsonb);

I've tried a patch to implement it.
(i raised the issue at
https://www.postgresql.org/message-id/CACJufxFWiCnG3Q7f0m_GdrytPbv29A5OWngCDwKVjcftwzHbTA%40mail.gmail.com
i think a new thread would be more appropriate).



current json_value  doc:
"Note that scalar strings returned by json_value always have their
quotes removed, equivalent to specifying OMIT QUOTES in json_query."

i think there are two exceptions: when the returning data types are
jsonb or json.



pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Support "Right Semi Join" plan shapes
Next
From: Heikki Linnakangas
Date:
Subject: Injection point locking