PG 11.5 on linux Let's say I store a jsonb in a column called test_results that looks like this...
{ 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} } } And I want to to get all the port names where the mean is >= 7. This works... select 1 from mytbl where cast(test_results#>'{ports,*port_abc*,mean}' as float) >= 7 ; But I want *all *the ports that have mean >= 7. Something akin to... select 1 from mytbl where cast(test_results#>'{ports,***,mean}' as float) >= 7 ; But the "*" doesn't work :-( Any ideas ? Thanks!