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

Started by Nonameover 10 years ago2 messagesbugs
Jump to latest
#1Noname
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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: BUG #13503: json_to_hstore does not works with backslash-quote in json value

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs