gistfile1.txt

test=# select * from files f left join refs r on f.refid = r.id left join repos p on r.repoid = p.id left join types t on t.id = p.typeid;
 id | refid |  id  | repoid |  id  | typeid |  id  |  name  
----+-------+------+--------+------+--------+------+--------
  2 |     1 |    1 |      2 |    2 |      3 |    3 | boxnet
  3 |     2 |    2 |   NULL | NULL |   NULL | NULL | NULL
  1 |  NULL | NULL |   NULL | NULL |   NULL | NULL | NULL
(3 řádky)

test=# select * from files f left join refs r on f.refid = r.id join repos p on r.repoid = p.id join types t on t.id = p.typeid;
 id | refid | id | repoid | id | typeid | id |  name  
----+-------+----+--------+----+--------+----+--------
  2 |     1 |  1 |      2 |  2 |      3 |  3 | boxnet
(1 řádka)