json query problem

From: "john(dot)tiger" <john(dot)tigernassau(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: json query problem
Date: 2014-01-02 19:19:52
Message-ID: 52C5BBD8.10401@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2014-01-02 20:37:43 Re: json query problem
Previous Message Merlin Moncure 2014-01-02 16:56:01 Re: How to delete completely duplicate rows