Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group