Re: WHERE order - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WHERE order
Date
Msg-id 18733.1061936296@sss.pgh.pa.us
Whole thread Raw
In response to WHERE order  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
Rod Taylor <rbt@rbt.ca> writes:
> I would think that a simple optimization would be to push off evaluation
> of a subplan whenever possible by re-arranging AND statements.

Thought we did that already ... [ checks code ] ... hmph, it looks like
this is done correctly for quals attached to a scan node, but not for
quals attached to a join node.  Oops.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Marie G. Tuite"
Date:
Subject: before trigger problem
Next
From: Tom Lane
Date:
Subject: Re: Date input changed in 7.4 ?