Re: json query problem

I take that back, basic JSON support was introduced in PostgreSQL 9.2, and
a back-port of its functionality is also available for 9.1 here:
https://bitbucket.org/adunstan/json_91

On Thu, Jan 2, 2014 at 4:04 PM, Joshua D. Burns <joshuadburns(at)hotmail(dot)com>wrote:

> The information on apt.postgresql.org was a little outdated, the last I
> checked.
>
> For information which is sure to be up to date, check out:
> http://www.postgresql.org/download/linux/debian/
>
> They describe how to add the repo to your Debian install, allowing you to
> update to PostgreSQL 9.3+.
>
> The JSON data type was implemented in 9.3. 9.4 (still under development,)
> brings some HUGE enhancements to the storage mechanism behind HSTORE and
> JSON, which I'd hop on the moment it is released as stable.
>
>
> On Thu, Jan 2, 2014 at 3:37 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
>
>> On 02/01/2014 19:19, john.tiger wrote:
>> > trying to select a row of json type returning the entire json record
>> >
>> > table users id, jsondata
>> > jsondata has {"username":"jdoe", ....}
>> >
>> > select json_to_row from users where jsondata->"username" = "jdoe";
>> > fails on operator -> unknown
>> >
>> > using debian testing with postgresql backport ppa
>> > psql: 9.3.2 server 9.2.6
>> >
>> > do I need a higher server version ? is there a 9.3 server available for
>> > debian ?
>>
>> Dunno about the JSON question, but you can get current Debian versions
>> of PostgreSQL from http://apt.postgresql.org.
>>
>> Ray.
>>
>>
>> --
>> Raymond O'Donnell :: Galway :: Ireland
>> rod(at)iol(dot)ie
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>>
>