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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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