Search Postgresql Archives

Re: Counting # of consecutive rows with specified value(s)?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Ken Tanzer <ken.tanzer@xxxxxxxxx>
Subject: Re: Counting # of consecutive rows with specified value(s)?
From: François Beausoleil <francois@xxxxxxxxxxx>
Date: Thu, 7 Jun 2012 15:35:35 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <CAD3a31WWFsk6t5MaxQDNBt5x5J-M4_cpFRyiLpQ8x18tA+YWsg@mail.gmail.com>

Le 2012-06-06 à 22:20, Ken Tanzer a écrit :

I can currently test whether someone has at least a specified number of consecutive absences with the query below, but it would be better to get the actual number.

As a second question, what about getting the number of consecutive records for a set of values? (e.g., attendance_code IN ('ATTENDED','EXCUSED')

Any ideas or suggestions? Thanks.

This is similar to the islands and gaps problem. Search for that on StackOverflow and you'll get it.

Bye!

François

Follow-Ups:
- Re: Counting # of consecutive rows with specified value(s)?
  - From: Ken Tanzer

References:
- Counting # of consecutive rows with specified value(s)?
  - From: Ken Tanzer

Prev by Date: Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?!
Next by Date: Re: Missing row after update
Previous by thread: Re: Counting # of consecutive rows with specified value(s)?
Next by thread: Re: Counting # of consecutive rows with specified value(s)?
Index(es):
- Date
- Thread

[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Add to Google

Powered by Linux