diff options
Diffstat (limited to 'content/posts/nested-postgres-results/composite-array-agg.sql')
| -rw-r--r-- | content/posts/nested-postgres-results/composite-array-agg.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/content/posts/nested-postgres-results/composite-array-agg.sql b/content/posts/nested-postgres-results/composite-array-agg.sql new file mode 100644 index 0000000..0def84f --- /dev/null +++ b/content/posts/nested-postgres-results/composite-array-agg.sql @@ -0,0 +1,8 @@ +SELECT + accommodation_id, + array_agg((date, price)) AS daily_configs +FROM + overrides +WHERE '[2025-07-01,2025-07-08)'::daterange +@> date +GROUP BY overrides.accommodation_id |