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.
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?
db=> SELECT to_json('"a"=>1, "b"=>2'::hstore); to_json ------------------------------ "\"a\"=>\"1\", \"b\"=>\"2\""
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных