By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 4 Duplicates: 0 Warnings: 0
| result |
|---|
| [(test1,device_1,2,1),(test1,device_2,3,0)] |
| [(test2,device_1,1,2),(test2,device_2,2,1)] |
Records: 4 Duplicates: 0 Warnings: 0
| result |
|---|
| [(test1,device_1,2,1),(test1,device_2,3,0)] |
| [(test2,device_1,1,2),(test2,device_2,2,1)] |