title: PostgreSQL - time series interpolation
body: <p>I have a table "performances" with columns "date" and "count".
  However, the rows are sparse i.e. there are many days for which there is no row, which implicitly means that the count = 0.
  Is there a query I can do that when run on this:</p>
  
  <pre><code>date       count
  2016-7-15  3
  2016-7-12  1
  2016-7-11  2
  </code></pre>
  
  <p>Would give me this:</p>
  
  <pre><code>date       count
  2016-7-15  3
  2016-7-14  0
  2016-7-13  0
  2016-7-12  1
  2016-7-11  2
  </code></pre>
  
  <p>?</p>