By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
| id | date | user_id | value | array_agg |
|---|---|---|---|---|
| 1 | 2022-07-13 16:42:33.1233 | 1 | 123 | {12365,12,12345} |
| 2 | 2022-07-13 16:41:33.1233 | 1 | 12345 | {12365,12} |
| 3 | 2022-07-13 16:40:33.1233 | 1 | 12 | {12365} |
| 4 | 2022-07-13 16:39:33.1233 | 1 | 12365 | null |
| 5 | 2022-07-13 16:37:33.1233 | 2 | 123234 | {3234,1234,123} |
| 6 | 2022-07-13 16:36:33.1233 | 2 | 123 | {3234,1234} |
| 7 | 2022-07-13 16:35:33.1233 | 2 | 1234 | {3234} |
| 8 | 2022-07-13 16:34:33.1233 | 2 | 3234 | null |
| 9 | 2022-07-13 16:33:33.1233 | 3 | 1234 | null |