Re: Generate a series of single days from a table of intervals.

Hi, and thanks for your quick reply,


> https://www.postgresql.org/docs/9.5/static/functions-srf.html


I know about generate_series, but I would like this to
be generally applicable.


> See "LEFT JOIN" and "COALESCE"
>

Will do.

>> 2016-04-02       0

> Typo?

Yes :-)


>> I would like to do this using a recursive CTE if it's the best solution,
>> but I'm open to other approaches - different approaches appreciated.


> Really?  That should be the last choice of execution strategy.

> This isn't a tree, I'm doubtful that a recursive CTE is needed.

But recursive CTEs can be used to generate series, and as I
said, I don't want to use a PostgreSQL specific function.

> https://www.postgresql.org/docs/9.5/static/functions-range.html

Will take a look, thanks again,


Paul...


> David J.