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.