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

Re: grouping by time interval

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Michael Lush <mjlush(at)ebi(dot)ac(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: grouping by time interval
Date: 2009-04-01 20:05:27
Message-ID: alpine.BSF.2.00.0904011504580.5151@thebighonker.lerctr.org (view raw or flat)
Thread:
Lists: 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(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

In response to

Responses

pgsql-novice by date

Next:From: Robert SchnabelDate: 2009-04-02 16:13:59
Subject: WAL and TMP directory locations
Previous:From: Michael LushDate: 2009-04-01 15:08:35
Subject: grouping by time interval

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