I am creating a small booking system, and need to generate a series of dates, for the year, with each booking. Using generate_series I can create the dates, and fill them with a booking date based on the lower tsrange for the booking.
I need to extend this to also fetch ALL the dates in the tsrange.
This is the schema and story so far.
All help gratefully welcomed.
Thanks,
Kev