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 11:40:22
Message-ID: 1c23c8e70705100440g6550997ah2fbe670d2c01f3db@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 5/10/07, Oliveiros Cristina <oliveiros(dot)cristina(at)marktest(dot)pt> wrote:
>
>  Yes,I've already figured out the mistake.
> Can you please try this one?
> Please Tell me if it worked
>


I worked! Thanks a lot, Oliveiros.

I didn't understand which is the aim of the condition
WHERE (((b."date" - a."date") = 1) OR (b."date" - a."date") = 0)

 And should I modify the query if the time interval ( in days ) is varing?



Loredana

In response to

Responses

pgsql-novice by date

Next:From: Oliveiros CristinaDate: 2007-05-10 13:37:07
Subject: Re: Fw: Count rows group by time intervals
Previous:From: Oliveiros CristinaDate: 2007-05-10 11:03:30
Subject: Re: Fw: Count rows group by time intervals

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