lms(date) AS
  SELECT * FROM films WHERE date_prod &gt; $1;
CREATE TEMP TABLE films_recent ON COMMIT DROP AS
  EXECUTE recentfilms('2002-01-01');
</pre></div><div class="refsect1" id="id-1.9.3.86.9"><h2>Compatibility</h2><p>
   <code class="command">CREATE TABLE AS</code> conforms to the <acronym class="acronym">SQL</acronym>
   standard.  The following are nonstandard extensions:

   </p><div class="itemizedlist"><ul class="itemizedlist compact" style="list-style-type: disc; "><li class="listitem"><p>
    