| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Schnabel | 2009-04-02 16:13:59 | WAL and TMP directory locations |
| Previous Message | Michael Lush | 2009-04-01 15:08:35 | grouping by time interval |