composite-array-agg.sql « nested-postgres-results « posts « content - kagamino_blog - Unnamed repository; edit this file 'description' to name the repository.

about summary refs log tree commit diff

path: root/content/posts/nested-postgres-results/composite-array-agg.sql

blob: 0def84f90f0b160c77f0729af286da1c07f0769f (plain) (blame)


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