json query problem - Mailing list pgsql-general

From john.tiger
Subject json query problem
Date
Msg-id 52C5BBD8.10401@gmail.com
Whole thread Raw
In response to Re: Format of Pioint datatype.... lat/long or long/lat??  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: json query problem  (Raymond O'Donnell <rod@iol.ie>)
Re: json query problem  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
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 ?



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: How to delete completely duplicate rows
Next
From: Raymond O'Donnell
Date:
Subject: Re: json query problem