title: Create multiple incrementing columns using with recursive in postgresql
body: <p>I'm trying to create a table with the following columns:</p>
  
  <p><a href="https://i.stack.imgur.com/pDdif.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pDdif.png" alt="enter image description here"></a></p>
  
  <p>I want to use a with recursive table to do this. The following code however is giving the following error: </p>
  
  <blockquote>
    <p>'ERROR: column "b" does not exist' </p>
  </blockquote>
  
  <pre><code>WITH recursive numbers AS 
  ( 
    SELECT 1,2,4 AS a, b, c 
    UNION ALL 
    SELECT a+1, b+1, c+1 
    FROM Numbers 
    WHERE a + 1 &lt;= 10 
  ) 
  SELECT * FROM numbers;
  </code></pre>
  
  <p>I'm stuck because when I just include one column this works perfectly. Why is there an error for multiple columns?</p>