Re: Query on JSON field type

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