By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
LEVEL | PARENT | CHILD |
---|---|---|
1 | b | c |
2 | c | d |
3 | d | e |
LEVEL | COL1 | COL2 | PATH |
---|---|---|---|
1 | a | b | ->(a,b) |
2 | a | b | ->(a,b)->(a,b) |
3 | a | b | ->(a,b)->(a,b)->(a,b) |
3 | c | d | ->(a,b)->(a,b)->(c,d) |
2 | c | d | ->(a,b)->(c,d) |
3 | a | b | ->(a,b)->(c,d)->(a,b) |
3 | c | d | ->(a,b)->(c,d)->(c,d) |
1 | c | d | ->(c,d) |
2 | a | b | ->(c,d)->(a,b) |
3 | a | b | ->(c,d)->(a,b)->(a,b) |
3 | c | d | ->(c,d)->(a,b)->(c,d) |
2 | c | d | ->(c,d)->(c,d) |
3 | a | b | ->(c,d)->(c,d)->(a,b) |
3 | c | d | ->(c,d)->(c,d)->(c,d) |