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 <[email protected]> wrote: > On 2011-06-03, [email protected] <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
