David Ford <david+cert@blue-labs.org> writes:
> As stated above, I'd like to fetch a count of rows
> per day for the last N days.
GROUP BY seems like the obvious answer...
> In the near future I'm going to split this table up into many sub tables
Why? Aren't you just going to have a need for lots of joins, if you
do that?
regards, tom lane