Re: grouping by time interval

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: grouping by time interval
Дата
Msg-id alpine.BSF.2.00.0904011504580.5151@thebighonker.lerctr.org
обсуждение исходный текст
Ответ на grouping by time interval  (Michael Lush <mjlush@ebi.ac.uk>)
Ответы Re: grouping by time interval  (Michael Lush <mjlush@ebi.ac.uk>)
Список pgsql-novice
On Wed, 1 Apr 2009, Michael Lush wrote:

>
> I'm writing a photo database for my family photos.  I've got a massive back
> log so I'd like to some large scale annotation and break things up into
> manageable chunks.
>
> I think one useful assumption would be tha any set of photos taken within of
> a few seconds of each other (say 5 or less) are /probably/ about the same
> subject...
>
> How would I go about detecting and marking events where the time interval
> between two photos is less than 5 seconds
>
[snip]

Have a look at the OVERLAPS operator.


--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Lush
Дата:
Сообщение: grouping by time interval
Следующее
От: Robert Schnabel
Дата:
Сообщение: WAL and TMP directory locations