=?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?= <[EMAIL PROTECTED]> writes: > As far as I know SQL Server has some similar feature. It does not join > if not necessary, more exactly: if the result would be the same if it > joined the table.
I find it really really hard to believe that such cases arise often enough to justify having the planner spend cycles checking for them. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq