Re: partitioned table query question

On Dec 10, 2007, at 1:21 PM, Erik Jones wrote:

> You beat me to the punch on this one.  I was wanting to use modulo  
> operations for bin style partitioning as well, but this makes things  
> pretty awkward as well as unintuitive.  So, to the postgres gurus:    
> What are the limitations of check constraints when used with  
> constraint exclusion?  Is this really the intended behavior?
>

/me too!

I have vague recollection of reading that the constraints on the child  
tables needed to be free of computation (ie, just straight comparison  
ranges) but I can't find that reference now.

But in my case, I can almost always pick the appropriate sub-table  
from the application level anyway.