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.