Re: returning row numbers in select

On Wed, Mar 10, 2004 at 17:25:49 -0500,
  Randall Skelton <skelton@brutus.uwaterloo.ca> wrote:
>
> That would be ideal as it is theoretically possible for there to be
> missing rows due to sampling errors; nevertheless, a WHERE test doesn't
> seem obvious to me.  Can you please post an example?  The time spacing
> between rows is 1 second but I want my select statement to return rows
> every 5 seconds (see marked lines below).  I've tried various interval
> operations but I don't really understand how to relate the timestamp
> and and the interval.

You could extract seconds from timestamp, cast to integer and apply
the mod function and test against whichever remainder you want.