Per report of Armin Ronacher, it's not clear how to take a scalar JSON string and unquote it into a regular Postgres "text" value, given what I can see here: http://www.postgresql.org/docs/9.3/static/functions-json.html
Example: SELECT '"a json string"'::json; (Although this some problem could play out with other scalar JSON types): SELECT '4'::json; SELECT '2.0'::json; This use cases arises from some of the extant unpacking operations, such as json_array_elements. It's not that strange to have a value something something like this in a JSON: '{"tags": ["a \" string", "b", "c"]}' Thoughts? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers