Re: BUG #17525: Range partition by date won't allow the use of a date that is the upper bound

> On Jun 21, 2022, at 16:11, PG Bug reporting form <noreply@postgresql.org> wrote:
> e.g. CREATE TABLE avm.avm_history_201704 PARTITION OF avm.avm_history_part
>    FOR VALUES FROM ('2017-04-01') TO ('2017-04-30');

The upper bound on a range partition is exclusive: The partition is defined as from 2017-04-01 up to, but not including
2017-04-30. If you want full-month partitions, you probably want the upper bound to be 2017-05-01 (in this example).