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 1c23c8e70705100440g6550997ah2fbe670d2c01f3db@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
On 5/10/07, Oliveiros Cristina <oliveiros.cristina@marktest.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


pgsql-novice by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Re: Fw: Count rows group by time intervals
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: Fw: Count rows group by time intervals