title: Postgres SQL select a range of records spaced out by a given interval
body: <p>I am trying to determine if it is possible, using only sql for postgres, to select a range of time ordered records at a given interval.   </p>
  
  <p>Lets say I have 60 records, one record for each minute in a given hour.  I want to select records at 5 minute intervals for that hour.  The resulting rows should be 12 records each one 5 minutes apart.</p>
  
  <p>This is currently accomplished by selecting the full range of records and then looping thru the results and pulling out the records at the given interval.  I am trying to see if I can do this purly in sql as our db is large and we may be dealing with tens of thousands of records.   </p>
  
  <p>Any thoughts?</p>