By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| gid | id | c1 | c2 |
|---|---|---|---|
| 1 | 1 | p1 | e1 |
| 1 | 2 | p2 | e2 |
| 1 | 3 | p1 | e2 |
| 2 | 4 | p3 | e3 |
| 2 | 5 | p3 | e4 |
| 2 | 6 | p4 | e4 |
6 rows affected
| gid | id | c1 | c2 |
|---|---|---|---|
| 1 | 1 | p1 | e1 |
| 1 | 2 | p2 | e2 |
| 1 | 3 | p1 | e2 |
| 2 | 4 | p3 | e3 |
| 2 | 5 | p3 | e4 |
| 2 | 6 | p4 | e4 |