title: Postgresql: using 'with clause' to iterate over a range of dates
body: <p>I have a database table that contains a start visdate and an end visdate. If a date is within this range the asset is marked available. Assets belong to a user. My query takes in a date range (start and end date). I need to return data so that for a date range it will query the database and <strong>return a count of assets for each day in the date range that assets are available.</strong></p>
  
  <p>I know there are a few examples, I was wondering if it's possible to just execute this as a query/common table expression rather than using a function or a temporary table. I'm also finding it quite complicated because the assets table does not contain one date which an asset is available on. I'm querying a range of dates against a visibility window. What is the best way to do this? Should I just do a separate query for each day in the date range I'm given?</p>
  
  <pre><code>Asset Table
  StartvisDate Timestamp
  EndvisDate   Timestamp
  ID           int
  
  User Table
  ID
  
  User &amp; Asset Join table
  UserID
  AssetID
  
  
  Date       | Number of Assets Available | User
  11/11/14              5                   UK
  12/11/14              6                   Greece
  13/11/14              4                   America
  14/11/14              0                   Italy
  </code></pre>