On Wednesday, November 18, 2020, Snjezana Frketic < frketic.snjez...@gmail.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.