> > OTOH I've seen a lot of people bitten by [2014-01-01,2014-12-31] on > TIMESTAMP intervals. >
No argument there. > Everybody remembers december has 31 days, but when we have to do > MONTHLY partitions if you use closed intervals someone always miskeys > the number of days, or forgets wheter a particular year is leap or > not, and when doing it automatically I always have to code it as start > + 1 month - 1day. In my experience having the non-significant part of > the dates ( days in monthly case, months too in yearly cases ) both 1 > and equal in start and end makes it easier to check and identify, and > less error prone. > Being able to define partitions by expressions based on the values I want would be a good thing. > You just do the classical ( I've had to do it ) closed end || minimum > char ( "XYZ","XYZ\0" in this case ). It is not that difficult as > strings have a global order, the next string to any one is always that > plus the \0, or whatever your minimum is. > I've thought about doing that in the past, but wasn't sure it would actually work correctly. If you have experience with it doing so, that would be encouraging. How does that *look* when you print your partition layout though?