Re: selecting records X minutes apart - Mailing list pgsql-sql

From Jasen Betts
Subject Re: selecting records X minutes apart
Date
Msg-id isd5s4$86l$1@reversiblemaps.ath.cx
Whole thread Raw
In response to selecting records X minutes apart  (lists-pgsql@useunix.net)
Responses Re: selecting records X minutes apart  (Kevin Crain <kevin.crain1@gmail.com>)
Re: selecting records X minutes apart  (lists-pgsql@useunix.net)
List pgsql-sql
On 2011-06-03, lists-pgsql@useunix.net <lists-pgsql@useunix.net> wrote:
>
> ID    TS (HH:MM)
> -------------------
> 0    20:00
> 0    20:05
> 0    20:10
> 1    20:03
> 1    20:09
>
>
> Does my question make sense?

no, why is (1,20:04) excluded, but (0,20:05) included?
both records are 5 minutes from the newest.

-- 
⚂⚃ 100% natural



pgsql-sql by date:

Previous
From: Kevin Crain
Date:
Subject: Re: selecting records X minutes apart
Next
From: Kevin Crain
Date:
Subject: Re: selecting records X minutes apart