title: can't use JOIN with generate_series on Redshift
body: <p>generate_series function on Redshift works as expected, when used in a simple select statement. </p>
  
  <pre><code>WITH series AS (
      SELECT n as id from generate_series (-10, 0, 1) n
  ) SELECT * FROM series;
  -- Works fine
  </code></pre>
  
  <p>As soon as I add a JOIN condition, redshift throws</p>
  
  <blockquote>
    <p>com.amazon.support.exceptions.ErrorException: Function
    generate_series(integer,integer,integer)" not supported"</p>
  </blockquote>
  
  <pre><code>DROP TABLE testing;
  CREATE TABLE testing (
    id INT
  );
  WITH series AS (
    SELECT n as id from generate_series (-10, 0, 1) n
  ) SELECT * FROM series S JOIN testing T ON S.id = T.id;
  -- Function "generate_series(integer,integer,integer)" not supported.
  </code></pre>
  
  <p>Redshift Version</p>
  
  <pre><code>SELECT version();
  -- PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.1485
  </code></pre>
  
  <p>Are there any workarounds to make this work?</p>