From 637302a61ee9b4ef84e5c152a17af442599a8e2a Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Mon, 29 Sep 2025 18:42:44 +0200 Subject: Draft ready for PostgreSQL aggregation processing speed --- content/posts/nested-postgres-results/json-array-agg.sql | 11 ----------- 1 file changed, 11 deletions(-) delete mode 100644 content/posts/nested-postgres-results/json-array-agg.sql (limited to 'content/posts/nested-postgres-results/json-array-agg.sql') diff --git a/content/posts/nested-postgres-results/json-array-agg.sql b/content/posts/nested-postgres-results/json-array-agg.sql deleted file mode 100644 index a7ca29c..0000000 --- a/content/posts/nested-postgres-results/json-array-agg.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - accommodation_id, - json_agg(json_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