listitem"><p>
       Create the <code class="structname">measurement</code> table as a partitioned
       table by specifying the <code class="literal">PARTITION BY</code> clause, which
       includes the partitioning method (<code class="literal">RANGE</code> in this
       case) and the list of column(s) to use as the partition key.

</p><pre class="programlisting">
CREATE TABLE measurement (
    city_id         int not null,
    logdate         date not null,
    peaktemp        int,
    unitsales      