On Thu, Mar 13, 2014 at 12:15 PM, Joe Van Dyk <joe(at)tanga(dot)com> wrote:
> I've got a postgresql 9.3.2 server, compiled from scratch. Getting this
> error:
>
> # select hstore('a', 'b')::json;
> ERROR: cannot cast type hstore to json
> LINE 1: select hstore('a', 'b')::json;
> ^
> # select array_to_json(array[hstore('a', 'b')]);
> array_to_json
> ------------------
> ["\"a\"=>\"b\""]
> (1 row)
>
> (I expected [{"a": "b"}] )
>
> I don't get this on other postgresql installations. Any ideas?
>
> Joe
>
ALTER EXTENSION hstore UPDATE; fixed the problem. (thanks oicu!)