How to select values in a JSON type of column?

2020-11-18 Thread Snjezana Frketic
Hi! I have a column called targeting in a table called campaigns . The column looks like { "targets": [ { "audienceSegments": [ { "includes": [ { "consumer": "selection", "segments": { "allOf": [

Re: How to select values in a JSON type of column?

2020-11-18 Thread Snjezana Frketic
I looked at it yesterday, but I couldn't figure it out because my JSON is more nested and I got lost going down the path. On Wed, 18 Nov 2020 at 15:40, David G. Johnston wrote: > > On Wednesday, November 18, 2020, Snjezana Frketic < > frketic.snjez...@gmail.com> wrot

Re: How to select values in a JSON type of column?

2020-11-18 Thread Snjezana Frketic
I actually have version 9.3.17 😬 On Wed, 18 Nov 2020 at 15:55, Thomas Kellerer wrote: > Snjezana Frketic schrieb am 18.11.2020 um 11:29: > > I have a column called |targeting| in a table called |campaigns| . > > [...] > > and I need to select all the |ids| in |includes|

Re: How to select values in a JSON type of column?

2020-11-18 Thread Snjezana Frketic
Unfortunately, I also can not update my version :) On Wed, 18 Nov 2020 at 17:00, Snjezana Frketic wrote: > I actually have version 9.3.17 😬 > > > On Wed, 18 Nov 2020 at 15:55, Thomas Kellerer wrote: > >> Snjezana Frketic schrieb am 18.11.2020 um 11:29: >> > I h

Re: How to select values in a JSON type of column?

2020-11-18 Thread Snjezana Frketic
Fair point. Appreciate your help nevertheless :) On Wed, 18 Nov 2020 at 17:30, David G. Johnston wrote: > On Wed, Nov 18, 2020 at 9:23 AM Snjezana Frketic < > frketic.snjez...@gmail.com> wrote: > >> Unfortunately, I also can not update my version :) >> > >