Re: can't cast hstore to json

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Van Dyk <joe(at)tanga(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: can't cast hstore to json
Date: 2014-03-13 19:22:36
Message-ID: 7178.1394738556@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Van Dyk <joe(at)tanga(dot)com> writes:
> 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

Probably need to update the hstore extension to 1.2.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-03-13 19:25:39 Re: puzzling perl DBI vs psql problem
Previous Message Joe Van Dyk 2014-03-13 19:22:13 Re: can't cast hstore to json