Re: selecting records X minutes apart

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: selecting records X minutes apart
Date: 2011-06-04 11:45:08
Message-ID: isd5s4$86l$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2011-06-03, lists-pgsql(at)useunix(dot)net <lists-pgsql(at)useunix(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kevin Crain 2011-06-04 15:49:09 Re: selecting records X minutes apart
Previous Message Kevin Crain 2011-06-04 01:01:53 Re: selecting records X minutes apart