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.
http://pastie.org/10698843
Thanks,
Kev