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)
Список
Дерево обсуждения
How to out \df to a file "Craig" <craig@mysoftforge.com>
Re: How to out \df to a file Bruce Momjian <bruce@momjian.us>
Re: [personal] Re: How to out \df to a file "Craig" <craig@mysoftforge.com>
Re: [personal] Re: How to out \df to a file Bruce Momjian <bruce@momjian.us>
Re: How to out \df to a file "Wright, George" <George.Wright@infimatic.com>
Re: [personal] Re: How to out \df to a file "Craig" <craig@mysoftforge.com>
grouping by time interval Michael Lush <mjlush@ebi.ac.uk>
Re: grouping by time interval Larry Rosenman <ler@lerctr.org>
Re: grouping by time interval Michael Lush <mjlush@ebi.ac.uk>
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 по дате отправления