By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 3
CREATE TABLE
INSERT 0 3
| person_id | pets | person_name |
|---|---|---|
| 1 | [{"pet_id" : 1, "pet_name" : "Fluffy"}, {"pet_id" : 2, "pet_name" : "Buster"}] | John |
| 2 | [{"pet_id" : 3, "pet_name" : "Doggy"}] | Jill |
| 3 | [] | Mary |
SELECT 3