By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 9 Duplicates: 0 Warnings: 0
| key1 | key2 | ts | type | k2x |
|---|---|---|---|---|
| 1 | A | t0 | null | null |
| 1 | B | t1 | a | C |
| 1 | C | t1 | X | C |
| 1 | D | t2 | b | C |
| 1 | E | t3 | null | C |
| 1 | F | t4 | c | C |
| 1 | G | t5 | X | G |
| 1 | H | t5 | null | G |
| 1 | I | t6 | d | G |