Re: Query on JSON field type - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Query on JSON field type
Date
Msg-id CAHyXU0zwU31zwJfTb3kF+ST9KqjOf6SwKPnaK7aSCFbCCfgD_Q@mail.gmail.com
Whole thread Raw
In response to Query on JSON field type  (Mick <m.d.berceanu@gmail.com>)
Responses Re: Query on JSON field type
List pgsql-novice
On Wed, Nov 14, 2012 at 4:27 PM, Mick <m.d.berceanu@gmail.com> wrote:
> Hello,
> my field is called Samples and the value is {"R":100, "S":101, "Q":102}.  how do I find all Samples for which "R" =
100?
> Thank you in advance.

for xml type we have xpath function for these type of queries.
unfortunately, no analog for json type exists as of yet.  so, here our
our options:

*) pull to client side and filter there
*) search textually (say, by regular expression) and hope for the best
*) implement backend function in a language that speaks json, or can
be extended to do so.  pl/v8 and p/python are both noteworthy, but
almost all languages have json features of some kind.  your function
will do simple test and return bool for example.

merlin


pgsql-novice by date:

Previous
From: Igor Romanchenko
Date:
Subject: Re: to_number function
Next
From: "Cook, Brian - AIT"
Date:
Subject: How to add User with Read Only Access [INTERNAL]