RE: Wildcarding json keys in json query

I guess you could try something like this SELECT * FROM ( SELECT * from json_each(( '{ "ports" : { "port_abc":{"min": 5, "max": 7, "mean": 6}, "port_de

Re: Wildcarding json keys in json query

On Tue, Nov 30, 2021 at 1:40 PM David Gauthier wrote: > { > ports : { > port_abc:{min: 5, max: 7, mean: 6}, > port_def:{min: 5, max: 9, mean: 7}, > port_ghi:{min: 6, max: 10, mean: 8} > } > } > > select 1 from mytbl where cast(test_results#>'{ports,***,mean}' as float) > >= 7 ; >