sql/json miscellaneous issue
От | jian he |
---|---|
Тема | sql/json miscellaneous issue |
Дата | |
Msg-id | CACJufxEHgu8OWwm_+AXi1x9Kw4kjSX9wVLet2vTpGt76Q4Sf-w@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: sql/json miscellaneous issue
Re: sql/json miscellaneous issue |
Список | 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 по дате отправления: