Re: SQL for intervals

If you prefer recursive query. Here is an example: WITH Recurse (id, lo_bound, duration) AS ( SELECT id, t, 1
  FROM W lbound
 WHERE NOT EXISTS

       (SELECT *
          FROM W lower
         WHERE lower.id = lbound.id
           AND lower.t  = lbound.t - 1 day
       )

, lo_bound
, duration + 1

  FROM Recurse pre

, W new

 WHERE duration < 1000
   AND new.id = pre.id
   AND new.t = lo_bound + duration Day
)
SELECT id, lo_bound

, lo_bound + (MAX(duration)-1) Day up_bound
  FROM Recurse
 GROUP BY
       id, lo_bound; Received on Tue Dec 12 2006 - 13:36:55 CET