By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| id1 | id2 | ids |
|---|---|---|
| 1 | 2 | ,1,2, |
| 1 | 3 | ,1,2,3, |
| 1 | 4 | ,1,2,5,4, |
| 1 | 5 | ,1,2,5, |
| 2 | 1 | ,2,1, |
| 2 | 3 | ,2,3, |
| 2 | 4 | ,2,5,4, |
| 2 | 5 | ,2,5, |
| 3 | 1 | ,3,2,1, |
| 3 | 2 | ,3,2, |
| 3 | 4 | ,3,2,5,4, |
| 3 | 5 | ,3,2,5, |
| 4 | 1 | ,4,5,2,1, |
| 4 | 2 | ,4,5,2, |
| 4 | 3 | ,4,5,2,3, |
| 4 | 5 | ,4,5, |
| 5 | 1 | ,5,2,1, |
| 5 | 2 | ,5,2, |
| 5 | 3 | ,5,2,3, |
| 5 | 4 | ,5,4, |
| 6 | 7 | ,6,7, |
| 7 | 6 | ,7,6, |