Re: Fw: Count rows group by time intervals

From: "Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)com>
To: "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Fw: Count rows group by time intervals
Date: 2007-05-10 07:15:17
Message-ID: 1c23c8e70705100015l5921187dh955abfa0342f22a0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Loredana Curugiu 2007-05-10 08:01:03 Count rows by day interval
Previous Message Jim Nasby 2007-05-09 23:39:59 Re: Disk and shared buffer cache use