Adrian,
On Thu, Jan 15, 2015 at 9:09 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 01/15/2015 07:59 PM, Pawel Veselov wrote:
Hi.
I'm trying to cast hstore to json, but I don't seem to be getting a json
object from hstore key/value pairs.
[skipped]
db=> SELECT to_json('"a"=>1, "b"=>2'::hstore);
to_json
------------------------------
"\"a\"=>\"1\", \"b\"=>\"2\""
Works here:
business_app=> select version();
version
-----------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.5 on i686-pc-linux-gnu, compiled by gcc (SUSE Linux) 4.8.1 20130909 [gcc-4_8-branch revision 202388], 32-bit
(1 row)
business_app=> SELECT to_json('"a"=>1, "b"=>2'::hstore);
to_json
----------------------
{"a": "1", "b": "2"}
(1 row)
Did you upgrade from a previous version of Postgres?
Yes! From 9.1.14. 'alter extension hstore update' did the trick, thank you :)
[skipped]
