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
