Re: Query on JSON field type

From: Mick <m(dot)d(dot)berceanu(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Query on JSON field type
Date: 2012-11-15 20:11:56
Message-ID: 35647d3a-891e-419c-8279-3e88499c09d9@googlegroups.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thank you very much for your reply, Merlin :)

On Thursday, November 15, 2012 9:00:38 AM UTC-8, Merlin Moncure wrote:
> On Wed, Nov 14, 2012 at 4:27 PM, Mick 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
>
>
>
>
>
> --
>
> Sent via pgsql-novice mailing list
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgsql-novice

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Igor Romanchenko 2012-11-15 20:25:56 Re: How to add User with Read Only Access [INTERNAL]
Previous Message Cook, Brian - AIT 2012-11-15 17:59:07 How to add User with Read Only Access [INTERNAL]