CREATE TABLE list_parted (

a int

) PARTITION BY LIST (a);

CREATE TABLEpart_1 PARTITION OF list_parted FOR VALUES IN ('1');

CREATE TABLEpart_2 PARTITION OF list_parted FOR VALUES IN (2);

CREATE TABLEpart_3 PARTITION OF list_parted FOR VALUES IN ((2+1));

CREATE TABLEpart_p1 PARTITION OF list_parted FOR VALUES IN ('1');

CREATE TABLEpart_p2 PARTITION OF list_parted FOR VALUES IN (2);

CREATE TABLEpart_p3 PARTITION OF list_parted FOR VALUES IN ((2+1));

CREATE TABLE part_null PARTITION OF list_parted FOR VALUES IN (null);

\d+ list_parted

Partitioned table "public.list_parted"

Column | Type | Collation | Nullable | Default | Storage | Stats target | Description

--------+---------+-----------+----------+---------+---------+--------------+-------------

a | integer | | | | plain | |

Partition key: LIST (a)

Partitions:part_1 FOR VALUES IN (1),

part_2 FOR VALUES IN (2),

part_3 FOR VALUES IN (3),

part_null FOR VALUES IN (NULL)

Partitions:part_null FOR VALUES IN (NULL),

part_p1 FOR VALUES IN (1),

part_p2 FOR VALUES IN (2),

part_p3 FOR VALUES IN (3)

-- forbidden expressions for partition bound

CREATE TABLE part_bogus_expr_fail PARTITION OF list_parted FOR VALUES IN (somename);

CREATETABLElist_parted (

aint

) PARTITION BY LIST (a);

CREATETABLEpart_1 PARTITION OF list_parted FORVALUESIN ('1');

CREATETABLEpart_2 PARTITION OF list_parted FORVALUESIN (2);

CREATETABLEpart_3 PARTITION OF list_parted FORVALUESIN ((2+1));

CREATETABLEpart_p1 PARTITION OF list_parted FORVALUESIN ('1');

CREATETABLEpart_p2 PARTITION OF list_parted FORVALUESIN (2);

CREATETABLEpart_p3 PARTITION OF list_parted FORVALUESIN ((2+1));

CREATETABLEpart_null PARTITION OF list_parted FORVALUESIN (null);

\d+ list_parted