diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2025-09-07 21:35:50 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2025-09-07 21:35:50 +0200 |
| commit | 07871783082839a768e4fa999cee58532d0a79fe (patch) | |
| tree | 646f8b3be966e087dbdc6341c26d5fcddee89254 /content/posts/nested-postgres-results/jsonb-array-agg.sql | |
| parent | e083b5a37932ecf18efc73019a3fdb90e242cd7c (diff) | |
draft for nested postgres results
Diffstat (limited to 'content/posts/nested-postgres-results/jsonb-array-agg.sql')
| -rw-r--r-- | content/posts/nested-postgres-results/jsonb-array-agg.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/content/posts/nested-postgres-results/jsonb-array-agg.sql b/content/posts/nested-postgres-results/jsonb-array-agg.sql new file mode 100644 index 0000000..91d024c --- /dev/null +++ b/content/posts/nested-postgres-results/jsonb-array-agg.sql @@ -0,0 +1,11 @@ +SELECT + accommodation_id, + jsonb_agg(jsonb_build_object( + 'date', date, + 'price', price + )) AS daily_configs +FROM + overrides +WHERE '[2025-07-01,2025-07-08)'::daterange +@> date +GROUP BY overrides.accommodation_id |