Re: Casting hstore to json

Adrian,

On Thu, Jan 15, 2015 at 9:09 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
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]