The following bug has been logged on the website:
Bug reference: 11021
Logged by: Alexey
Email address: kolmyk(at)hotmail(dot)com
PostgreSQL version: 9.3.4
Operating system: Windows 8.0
Description:
I'm using json_each function for iterate keys and values in my function, but
string values contains quotes.
I can use json_each_text, but sometimes I need to json value.
Can I extract text value from json scalar?
Now I'm using this alternative script:
('[' || value ||']')::json->>0
Example:
select key, value, ('[' || value ||']')::json->>0 from
json_each('{"a":123,"b":"first"}');