On 12/20/19 6:49 PM, Wells Oliver wrote: > 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?
What is the mmd data type? I ask that because '2019-03-31' is really '2019-03-31 00:00:00.000', so there's nowhere for '2019-03-31 00:00:00.001' through '2019-03-31 23:59:59.999' to go. (And don't forget timezones.)