By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| id | matchers |
|---|---|
| 1 | [{"abc": 1, "pattern": "ABC"}, {"pattern": "ABAB"}, {"cde": "FOO", "pattern": "AABB"}] |
| 2 | [{"pattern": "AB"}, {"cde": "BAR", "pattern": "CDE"}] |
| 3 | [{"abc": 2, "pattern": "CD"}, {"pattern": "FG"}] |
| id | matchers |
|---|---|
| 2 | [{"pattern": "AB"}, {"cde": "BAR", "pattern": "CDE"}] |
| 1 | [{"abc": 1, "pattern": "ABC"}, {"pattern": "ABAB"}, {"cde": "FOO", "pattern": "AABB"}] |