Many were in favour of the default partition for tables partitioned by range [1].
Please find attached the WIP patch for the same which can be applied over the default_partition_v12.patch.
Syntax: Same as agreed for list:
CREATE PARTITION <part_name> PARTITION OF <parent_tbl> DEFAULT;
Default Constraint:
Negation constraints of all existing partitions.
One case:
CREATE TABLE range1 (a int, b int) PARTITION by range (a); CREATE TABLE range1_1 PARTITION OF range1 FOR VALUES FROM (1) TO (5); CREATE TABLE range1_2 PARTITION OF range1 FOR VALUES FROM (7) TO (10); CREATE TABLE range1_def PARTITION OF range1 DEFAULT; \d+ range1_def
