By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 6
| jsonb_set |
|---|
| {"blah": "blah", "owners": ["admin"]} |
| {"blah": "blah", "owners": ["john@google.com"]} |
| {"blah": "blah", "owners": ["2b877b4b825b48a9a0950dd5bd1f264d@2343ec78a04c6ea9d80806345d31fd78", "570a90bfbf8c7eab5dc5d4e26832d5b1@2343ec78a04c6ea9d80806345d31fd78"]} |
| {"blah": "blah", "owners": ["c96e3d164cfd5185b4fa408ed3778c15@2343ec78a04c6ea9d80806345d31fd78", "bill@google.com"]} |
| {"blah": "blah", "owners": ["eba9b9c3b1416e55f5e6431ef236c228@314a234c5818c7a83de8c055c21f728b"]} |
| {"blah": "blah", "owners": ["c31b32364ce19ca8fcd150a417ecce58@86a8244dadd9c002ebcc10ada515a84a"]} |
SELECT 6