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

Re: Fw: Count rows group by time intervals

From: "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
To: "Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Fw: Count rows group by time intervals
Date: 2007-05-10 13:37:07
Message-ID: 00f301c79308$4dfbd680$ec5a3d0a@marktestcr.marktest.pt (view raw or flat)
Thread:
Lists: pgsql-novice
Hello, Loredana.

Great to hear about the progress!!

Well, that part of the condition is to select the day, or the day after.

with the condition  ((a."date" - '2007-01-01' ) % 2 = 0 you obtain just the
even days, correct?

Then with the WHERE clause you are selecting, for a certain even day, all the records that match that day and the day after,  got the idea?

Then all you have to do it is COUNT them.

If it is to allow the time interval to vary, say you have a number of days of x.

Then you should change the HAVING clause to ((a."date" - '2007-01-01' ) % x = 0 , 
and change the WHERE clause to something like WHERE (((b."date" - a."date") >= 0) OR (b."date" - a."date") < x)
 
Try this, and please let me know if it solved the problem.

I use C# to access postgres database and it is very easy to parameterize a query with the NpgsqlParameter class.

I don't know if you are also using C# to interface with your database....

Take care

La revedere ,

Oliveiros :-)


  ----- Original Message ----- 
  From: Loredana Curugiu 
  To: Oliveiros Cristina ; pgsql-novice(at)postgresql(dot)org 
  Sent: Thursday, May 10, 2007 12:40 PM
  Subject: Re: Fw: [NOVICE] Count rows group by time intervals


  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 14:53:49
Subject: Re: Fw: Count rows group by time intervals
Previous:From: Loredana CurugiuDate: 2007-05-10 11:40:22
Subject: Re: Fw: Count rows group by time intervals

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