By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
| path | required_by |
|---|---|
| 1.2 | {3,4,5,6,7} |
| 1.2.2 | {5,6,7} |
SELECT 2
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
| path | required_by |
|---|---|
| 1.2 | {3,4,5,6,7} |
| 1.2.2 | {5,6,7} |
SELECT 2