Re: jsonb and where clause?

2017-11-28 Thread Bjorn T Johansen
On Tue, 28 Nov 2017 13:52:59 +0300 "Ivan E. Panchenko" wrote: > 28.11.2017 13:25, Bjorn T Johansen пишет: > > On Tue, 28 Nov 2017 11:28:55 +0300 > > "Ivan E. Panchenko" wrote: > > > >> Hi Bjorn, > >> > >> 28.11.2017 11:18, B

Re: jsonb and where clause?

2017-11-28 Thread Bjorn T Johansen
On Tue, 28 Nov 2017 11:28:55 +0300 "Ivan E. Panchenko" wrote: > 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

jsonb and where clause?

2017-11-28 Thread 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 colum