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@iol.ie