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/jsonb-array-agg.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 content/posts/nested-postgres-results/jsonb-array-agg.sql

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

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