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