ip       |                                      ports
----------------+--------------------------------------------------------------------------------------
 10.1.1.1       | {"port20": {"n": "10.1.1.2"}}
 10.1.1.2       | {"port5": {"n": "10.1.1.3"}, "port4": {"n": "10.1.1.1"}}
 10.1.1.3       | {"port1": {"n": "10.1.1.4"}, "port25": {"n": "10.1.1.2"}}
 10.1.1.4       | {"port6": {"n": "10.1.1.5"}, "port1": {"n": "10.1.1.3"}}
 10.1.1.5       | {"port8": {"n": "10.1.1.4"}}
 10.1.1.6       | {"port1": {"n": "10.1.1.7"}}
 10.1.1.7       | {"port2": {"n": "10.1.1.6"}}

WITH RECURSIVE r AS (
    SELECT value->>'n' n FROM jsonb_each((SELECT ports FROM switches WHERE ip = '10.1.1.3'))
  UNION
    SELECT value->>'n' FROM jsonb_each((SELECT ports FROM switches s WHERE s.ip = r.n))
)
SELECT * FROM switches WHERE ip IN (SELECT * FROM r)

ERROR:  missing FROM-clause entry for table "r"

SELECT *
  FROM invoice
 WHERE invoice.client_id=client.id AND client.created_at >= now() - INTERVAL '1 week';

SELECT *
FROM invoice
JOIN client on invoice.client_id=client.id
WHERE client.created_at >= now() - INTERVAL '1 week';

select s.ports::text from switches s join r on s.ip = r.n

select je.value->>'n' from switches s join r on s.ip = r.n cross join jsonb_each(s.ports) je