title: Getting date list in a range in PostgreSQL
body: <p>I'd like to get the list of days between the two dates (including them) in a <strong>PostgreSQL database</strong>. For example, if I had:</p>
  
  <ul>
  <li>start date: 29 june 2012</li>
  <li>end date: 3 july 2012</li>
  </ul>
  
  <p>then the result should be:</p>
  
  <pre><code>29 june 2012
  30 june 2012 
  1 july 2012 
  2 july 2012 
  3 july 2012
  </code></pre>
  
  <p>What would be the best way of doing this in PostgreSQL?</p>
  
  <p>Thanks.</p>