elwood(at)agouros(dot)de (Konstantinos Agouros) writes:
> I have a table where I enter some data with a full flexed datetime. Is there
> a _simple_ aggregate that I get the sum of entries for each day?
Maybe I'm missing something, but what's wrong with
select sum(datacol) from table group by date(timestampcol);
regards, tom lane