2019-09-30

postgresql partitions partition of table from to inclusive

When creating a range partition, the lower bound specified with FROM is an inclusive bound, whereas the upper bound specified with TO is an exclusive bound.

So in fact in
CREATE TABLE parsel_2014_10 PARTITION OF parsel_part 
     FOR VALUES FROM ('2014-10-01') TO ('2014-10-31');
the date 2014-10-31 is not included in this partition, and hence nowhere in all your partition tables (and same for all ending dates)

Niciun comentariu:

Trimiteți un comentariu