title: PostgreSQL Query to select data from last week?
body: <p>I have a table which has all the purchases of my costumers. I want to select all entries from the last week, (week start from Sunday).</p>
  
  <pre><code>id    value  date
  5907  1.20   "2015-06-05 09:08:34-03"
  5908  120.00 "2015-06-09 07:58:12-03"
  </code></pre>
  
  <p>I've tried this: </p>
  
  <pre><code>SELECT id, valor, created, FROM compras WHERE created &gt;= now() - interval '1 week' and parceiro_id= '1' 
  </code></pre>
  
  <p>But I got the data from the last week including data from this week, I only want data from the last week.</p>
  
  <p>How to get data only from last week ?</p>