github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_partition_range.sql (about) 1 CREATE TABLE students_by_range ( 2 id SERIAL, 3 name STRING, 4 email STRING, 5 country STRING, 6 expected_graduation_date DATE, 7 PRIMARY KEY (expected_graduation_date, id)) 8 PARTITION BY RANGE (expected_graduation_date) 9 (PARTITION graduated VALUES FROM (MINVALUE) TO ('2017-08-15'), 10 PARTITION current VALUES FROM ('2017-08-15') TO (MAXVALUE))