From 07871783082839a768e4fa999cee58532d0a79fe Mon Sep 17 00:00:00 2001
From: Martin Kagamino Lehoux <martin@lehoux.net>
Date: Sun, 7 Sep 2025 21:35:50 +0200
Subject: draft for nested postgres results

---
 content/posts/nested-postgres-results/composite-array-agg.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 content/posts/nested-postgres-results/composite-array-agg.sql

(limited to 'content/posts/nested-postgres-results/composite-array-agg.sql')

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
-- 
cgit v1.3