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_def":{"min": 5, "max": 9, "mean": 7},

                                                  "port_ghi":{"min": 6, "max": 10, "mean": 8}

                                                  }

                                              }'::json->'ports'

                                        ))

              ) T

WHERE (value::json->>'mean')::float >= 7;