4 ms·
I assume because that doesn't give the 0 results in the query. The RCTE would.
by dpcx 8y ago
I assume because that doesn't give the 0 results in the query. The RCTE would.
- blattimwind 8y agoAh 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.