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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

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