Re: [HACKERS] optimizing impossible matches

2004-03-10 Thread Merlin Moncure
Tom Lane wrote: > The optimizer has no knowledge of specific operators except what it > finds in the system catalogs. It has no way in general to determine > that a comparison involving nonconstant values must always fail. > Even if we could do it, I am dubious that it would be worth expending > t

Re: [HACKERS] optimizing impossible matches

2004-03-10 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > Is this really as simple as it seems? No. The optimizer has no knowledge of specific operators except what it finds in the system catalogs. It has no way in general to determine that a comparison involving nonconstant values must always fail. Even i