I've noticed a strange behavior in the generate_series functions.
I'm trying to get all days between a start and an end date including the bounds. So naturally I've tried something like the query below
.
As both your examples and previous responses highlight your problem is that generate_series is not defined for dates, I'll avoid further comments on this. As you are using dates and your working example is using dates I would suggest rewriting your query around to avoid implicits cast problems. Date difference is integer, generate_series is defined on them, so: