| From: | Kevin Crain <kevin(dot)crain1(at)gmail(dot)com> |
|---|---|
| To: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: selecting records X minutes apart |
| Date: | 2011-06-04 15:49:09 |
| Message-ID: | BANLkTimnn2zMO9C3BxTPHPPnRv1q-MGijQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
It looks like maybe he is trying to fetch records that either have no
previous entries or have another record with a timestamp 5 minutes
before them at the time they are inserted...
On Sat, Jun 4, 2011 at 4:45 AM, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:
> 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
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lists-pgsql | 2011-06-04 18:58:47 | Re: selecting records X minutes apart |
| Previous Message | Jasen Betts | 2011-06-04 11:45:08 | Re: selecting records X minutes apart |