Обсуждение: BUG #13503: json_to_hstore does not works with backslash-quote in json value

Поиск
Список
Период
Сортировка

BUG #13503: json_to_hstore does not works with backslash-quote in json value

От
kolmyk@hotmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      13503
Logged by:          Aleksei
Email address:      kolmyk@hotmail.com
PostgreSQL version: 9.4.1
Operating system:   Windows
Description:

select json_to_hstore('{"key":"\"quoted value\""}'::json)

-- ERROR:  Syntax error near '"' at position 7
-- CONTEXT:  SQL function "json_to_hstore" statement 1

Re: BUG #13503: json_to_hstore does not works with backslash-quote in json value

От
Tom Lane
Дата:
kolmyk@hotmail.com writes:
> select json_to_hstore('{"key":"\"quoted value\""}'::json)

> -- ERROR:  Syntax error near '"' at position 7
> -- CONTEXT:  SQL function "json_to_hstore" statement 1

There is no json_to_hstore() function in the standard Postgres
distribution, so we can't help you too much with whatever's
wrong with that function.

            regards, tom lane