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

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 <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

>
> On Wednesday, November 18, 2020, Snjezana Frketic <
> frketic(dot)snjezana(at)gmail(dot)com> wrote:
>
>>
>>
>> SELECT
>> targeting#>'{targets,0,audienceSegments,0,includes,0,segments,allOf,0,ids}'FROM
>> campaigns;
>>
>> and that works, but, I don’t want to have a fixed path because positions
>> could change like 0 could become 1, includes and excludes could change
>> positions, allOf could be anyOf etc.
>> Any idea of how to always select ids in includes no matter the changes?
>>
>
> Maybe it can be done using json path:
>
>
> https://www.postgresql.org/docs/13/functions-json.html#FUNCTIONS-SQLJSON-PATH
>
> David J.
>
>