On Sat, Aug 24, 2013 at 6:04 PM, Daniel Farina <daniel@fdr.io> wrote:
> But there's no good way I can find from the documentation to do it
> with a scalar: select ('"va\"lue"'::json)::text;
Triggered send by accident:
select ('"va\"lue"'::json)::text; text
-----------"va\"lue"
(1 row)
the JSON escaping is retained. That may be reasonable for a
text-cast, so I'm not suggesting its reinterpretation, but there is no
operator I can identify immediately from the documentation to convert
a JSON string value into a Postgres one like json_each_text, except on
a json that contains a scalar JSON string.