From: | "Ivan E(dot) Panchenko" <i(dot)panchenko(at)postgrespro(dot)ru> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: jsonb and where clause? |
Date: | 2017-11-28 08:28:55 |
Message-ID: | b9341406-f066-ea08-5c0d-1a7404a95df3@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Bjorn,
28.11.2017 11:18, Bjorn T Johansen пишет:
> Hi.
>
> Just starting to look at how to use jsonb columns and I have a question. I have found out that I can use the following to search for a value inside
> the jsonb column:
>
> select * from orders where info ->> 'customer' = 'John Doe' (where info is the jsonb column)
>
>
> But what if the jsonb column contains an json array, how can I search then?
>
> info -> [ { "customer" : "John Doe" } ]
If you know the index in array, you can search like
info->0->>'customer'
If you want to search in any array element, you need to use JSQUERY
extension,
see https://github.com/postgrespro/jsquery
>
>
> btw, using PostgreSQL 9.6 but will be moving to 10 soon.
>
>
> Regards,
>
> BTJ
>
Regards,
Ivan
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Holzer | 2017-11-28 08:50:16 | Plan for update ... where a is not distinct from b |
Previous Message | Bjorn T Johansen | 2017-11-28 08:18:07 | jsonb and where clause? |