Casting hstore to json
| От | Pawel Veselov |
|---|---|
| Тема | Casting hstore to json |
| Дата | |
| Msg-id | CAMnJ+Bdt9NCNnJeFvp-dHXF4wk0O_YZ5ExRqCSd5zau3hY3tfA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Casting hstore to json
|
| Список | pgsql-general |
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.
9.3 documentation says:
Note: The hstore extension has a cast from hstore to json, so that converted hstore values are represented as JSON objects, not as string values.
to_json(anyelement) - If the data type is not built in, and there is a cast from the type tojson, the cast function will be used to perform the conversion.
On 9.3.5 server:
db=> SELECT '"a"=>1, "b"=>2'::hstore;
hstore
--------------------
"a"=>"1", "b"=>"2"
(1 row)
db=> SELECT to_json('"a"=>1, "b"=>2'::hstore);
to_json
------------------------------
"\"a\"=>\"1\", \"b\"=>\"2\""
(1 row)
db=> SELECT cast(('"a"=>1, "b"=>2'::hstore) as json);
ERROR: cannot cast type hstore to json
LINE 1: SELECT cast(('"a"=>1, "b"=>2'::hstore) as json);
Thanks!
Pawel.
В списке pgsql-general по дате отправления: