x. Furthermore, <code class="command">CREATE
   TABLE AS</code> offers a superset of the functionality offered
   by <code class="command">SELECT INTO</code>.
  </p></div><div class="refsect1" id="id-1.9.3.86.8"><h2>Examples</h2><p>
   Create a new table <code class="literal">films_recent</code> consisting of only
   recent entries from the table <code class="literal">films</code>:

</p><pre class="programlisting">
CREATE TABLE films_recent AS
  SELECT * FROM films WHERE date_prod &gt;= '2002-01-01';
</pre>