Ah right. generate_series() might be another, possibly simpler way, to generate a time-series independent of what data in the relation actually exists and then

Ah right. generate_series() might be another, possibly simpler way, to generate a time-series independent of what data in the relation actually exists and then join and group that series to the data relation.