By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 3
| id | data |
|---|---|
| 1 | [{"a": 1}, {"a": 5}, {"a": 1}] |
| 2 | [{"a": 2}] |
| 3 | [{"a": 1}] |
SELECT 3
| id | value |
|---|---|
| 1 | {"a": 1} |
| 1 | {"a": 1} |
| 3 | {"a": 1} |
SELECT 3
CREATE TABLE
INSERT 0 3
| id | data |
|---|---|
| 1 | [{"a": 1}, {"a": 5}, {"a": 1}] |
| 2 | [{"a": 2}] |
| 3 | [{"a": 1}] |
SELECT 3
| id | value |
|---|---|
| 1 | {"a": 1} |
| 1 | {"a": 1} |
| 3 | {"a": 1} |
SELECT 3