content/posts/nested-postgres-results/json-array-agg.sql


1
2
3
4
5
6
7
8
9
10
11


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