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, 0 insertions, 8 deletions
diff --git a/content/posts/nested-postgres-results/composite-array-agg.sql b/content/posts/nested-postgres-results/composite-array-agg.sql deleted file mode 100644 index 0def84f..0000000 --- a/content/posts/nested-postgres-results/composite-array-agg.sql +++ /dev/null @@ -1,8 +0,0 @@ -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 |