Re: Partitioning by month causing an error?

Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> This is really interesting to me: why? Running select '2019-04-30'::date
> between '2019-04-01'::date and '2019-04-30'::date; yields true, and
> generally the lower and upper bounds are inclusive in any kind of between
> check for languages I am familiar with.

It's possible to do it like that for discrete types like dates. It's
not possible for continuous types. Exercise: try to write a partitioning
rule for a "numeric" column that classifies every value into one and only
one partition, if the partitioning behavior is like A <= X <= B.

(No fair restricting the precision of the numeric.)

regards, tom lane