By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 4
CREATE TABLE
INSERT 0 6
| id | url | tag_path |
|---|---|---|
| 1 | http://localhost:4000/Germany | [1] |
| 2 | http://localhost:4000/Germany/Hessen | [1, 2] |
| 2 | http://localhost:4000/Germany/Hessen | [1, 3] |
| 3 | http://localhost:4000/Germany/Hessen/Frankfurt | [1, 3, 4] |
| 3 | http://localhost:4000/Germany/Hessen/Frankfurt | [1, 2, 4] |
| 4 | http://localhost:4000/Germany/Hessen/Frankfurt/Example | [1, 2, 4, 5] |
| 4 | http://localhost:4000/Germany/Hessen/Frankfurt/Example | [1, 2, 4, 6] |
| 4 | http://localhost:4000/Germany/Hessen/Frankfurt/Example | [1, 3, 4, 5] |
| 4 | http://localhost:4000/Germany/Hessen/Frankfurt/Example | [1, 3, 4, 6] |
SELECT 9