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

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