title: Create a view on an integer?
body: <p>I have a table named A. it has only one record with one field. It is an integer named number.
  I want to create a view that have A.number records, each are one of the numbers less than A.number.</p>
  
  <p>For example:</p>
  
  <p>select A.number -----> 5</p>
  
  <p>the view should show 5 records  0  1  2  3  4</p>
  
  <p>P.S: This is a real problem that I simplified it a lot. The real problem is like dividing a budget in a fixed period to each day.</p>