By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 4
| json_col |
|---|
| [{"date": "2022-06-14T12:51:24.424Z", "name": "review_1"}] |
| [{"date": "2022-06-14T12:50:56.454Z", "name": "review_3"}, {"date": "2022-06-14T12:51:10.695Z", "name": "review_6"}] |
| [{"date": "2022-06-14T12:51:57.997Z", "name": "review_3"}] |
| [{"date": "2022-06-14T12:52:17.442Z", "name": "review_1"}, {"date": "2022-06-14T12:54:35.239Z", "name": "review_9"}] |
SELECT 4
| name | date |
|---|---|
| review_1 | 2022-06-14T12:51:24.424Z |
| review_3 | 2022-06-14T12:50:56.454Z |
| review_6 | 2022-06-14T12:51:10.695Z |
| review_3 | 2022-06-14T12:51:57.997Z |
| review_1 | 2022-06-14T12:52:17.442Z |
| review_9 | 2022-06-14T12:54:35.239Z |
SELECT 6