github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_subpartition.sql (about)

     1  CREATE TABLE students (
     2      id SERIAL,
     3      name STRING,
     4      email STRING,
     5      country STRING,
     6      expected_graduation_date DATE,
     7      PRIMARY KEY (country, expected_graduation_date, id))
     8      PARTITION BY LIST (country)(
     9          PARTITION australia VALUES IN ('AU','NZ') PARTITION BY RANGE (expected_graduation_date)(PARTITION graduated_au VALUES FROM (MINVALUE) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (MAXVALUE)),
    10          PARTITION north_america VALUES IN ('US','CA') PARTITION BY RANGE (expected_graduation_date)(PARTITION graduated_us VALUES FROM (MINVALUE) TO ('2017-08-15'), PARTITION current_us VALUES FROM ('2017-08-15') TO (MAXVALUE))
    11      )