Partitioning by month causing an error?

--000000000000df693d059a2c2b70
Content-Type: text/plain; charset="UTF-8"

I have a partition per each month, like this:

CREATE TABLE mmd_yr2019_3 PARTITION OF mmd FOR VALUES FROM ('2019-03-01')
TO ('2019-03-31');
CREATE TABLE mmd_yr2019_4 PARTITION OF mmd FOR VALUES FROM ('2019-04-01')
TO ('2019-04-30');

This breaks for dates at the end of the month. What's the better way to
write the bounds? 3/1 to 4/1 and then 4/1 to 5/1? Does that cause some
overlap issue?

Thanks.

-- 
Wells Oliver
[email protected] <[email protected]>

--000000000000df693d059a2c2b70
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>I have a partition per each month, like this:</div><d=
iv><br></div><div>CREATE TABLE mmd_yr2019_3 PARTITION OF mmd FOR VALUES FRO=
M (&#39;2019-03-01&#39;) TO (&#39;2019-03-31&#39;);<br>CREATE TABLE mmd_yr2=
019_4 PARTITION OF mmd FOR VALUES FROM (&#39;2019-04-01&#39;) TO (&#39;2019=
-04-30&#39;);</div><div><br></div><div>This breaks for dates at the end of =
the month. What&#39;s the better way to write the bounds? 3/1 to 4/1 and th=
en 4/1 to 5/1? Does that cause some overlap issue?</div><div><br></div><div=
>Thanks.<br></div><div><br>-- <br><div dir=3D"ltr" class=3D"gmail_signature=
" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div>Wells Oliver<br>=
<a href=3D"mailto:[email protected]" target=3D"_blank">wells.oliver@gma=
il.com</a></div></div></div></div></div>

--000000000000df693d059a2c2b70--