title: PSQL Select 1 record every 10 minutes
body: <p>I have a database where I have data inserted every minute, and I'm looking to pull out the record for every 10 minute interval:</p>
  
  <p>Example:
  I have data from 9:00 to 5:00 with 1 record every minute, I want to pull out 9:10, 9:20, 9:30, 9:40, etc.</p>
  
  <p>Right now I have:</p>
  
  <pre><code>select * from main where date = '2016-06-02' and time &gt; '09:00:00' and time &lt; '17:00:00'
  </code></pre>
  
  <p>This pulls all the records, but I want to limit it to only 10 minute intervals.</p>