By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | epos | tostring | i | v |
---|---|---|---|---|
1 | 2 | [2, 4] | 1 | 2 |
1 | 2 | [2, 4] | 2 | 4 |
2 | 3 | [10] | 1 | 10 |
3 | 1 | [2, 3, 4] | 1 | 2 |
3 | 1 | [2, 3, 4] | 2 | 3 |
3 | 1 | [2, 3, 4] | 3 | 4 |
4 | 4 | [10, 11] | 1 | 10 |
4 | 4 | [10, 11] | 2 | 11 |
id | epos | tostring | sort_str |
---|---|---|---|
3 | 1 | [2, 3, 4] | 00000002,00000003,00000004 |
1 | 2 | [2, 4] | 00000002,00000004 |
2 | 3 | [10] | 00000010 |
4 | 4 | [10, 11] | 00000010,00000011 |