Re: Count rows group by time intervals - Mailing list pgsql-novice

At 8:07a -0400 on 09 May 2007, Loredana Curugiu wrote:
> I have the following table:
>
> theme |   receiver        |           date
> ---------+----------------------+------------------------
>  LIA   | +40741775622 |  2007-04-27 00:00:00+00
>  LIA   | +40741775622 |  2007-04-25 00:00:00+00
>  MIA   | +40741775622 | 2007-04-27 00:00:00+00
>  MIA   | +40741775622 |  2007-05-09 00:00:00+00
>
> I would like to count rows group by theme, receiver, and time
> intervals of
> two days. I don't know how to start.

Should get you started:

SELECT
    COUNT( * ),
    theme,
    receiver,
    date
FROM
    yourTable
GROUP BY
    theme,
    receiver,
    date
;

Kevin