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 :-)