Postgres Pro
Downloads
Home   >   mailing lists

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

From Loredana Curugiu
Subject Re: Fw: Count rows group by time intervals
Date
Msg-id 1c23c8e70705100015l5921187dh955abfa0342f22a0@mail.gmail.com
Whole thread Raw
In response to Re: Fw: Count rows group by time intervals  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
List pgsql-novice
Tree view
Hi Oliveiros,

With your query I get the following result

          date                    | theme  |      receiver     | count
------------------------------------+----------+----------------------+-------
 2007-04-27 00:00:00+00 | MIA    | +40741775621 |    25
 2007-04-25 00:00:00+00 | LIA     | +40741775621 |    50
 2007-05-09 00:00:00+00 | MIA    | +40741775621 |     1
 2007-04-27 00:00:00+00 | LIA     | +40741775621 |    81

The count it is not correct.

Best,
      Loredana

pgsql-novice by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Disk and shared buffer cache use
Next
From: "Loredana Curugiu"
Date:
Subject: Count rows by day interval