title: How to select multiple rows filled with constants in Amazon Redshift?
body: <p>I have already tried the common PostgreSQL answer, but seems like it doesn't work with Redshift:</p>
  
  <pre><code>SELECT  * FROM VALUES (1) AS q (col1);
  
  ERROR: 42883: function values(integer) does not exist
  </code></pre>
  
  <p>I need this because for some reason I can't use <code>UNION ALL</code>. Any help will be greatly appreciated.</p>