Re: Casting hstore to json

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.

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?