Re: partitioned table query question

On Dec 11, 2007, at 10:44 AM, Gregory Stark wrote:

> The problem Tom's tried to explain is that the function may or may not
> preserve the bin. So for example if you wanted to bin based on the  
> final digit
> of a numeric number, so you had a constraint like

I, along with at least Erik, was thinking that the constraint  
expression would be evaluated to determine whether to include the  
partition in the final plan.  Based on Tom's description, it is not  
the case: the planner basically proves that the constraint will be  
false.  Until this was clarified, Tom's points totally confused the  
heck out of me.

It would be amazingly wonderful if this distinction could be posted to  
the online docs.  It will surely help future generations :-)