<div style="text-align: left; font-family: Tahoma,Helvetica,Sans-Serif;"><p class="MsoPlainText"><font size="3">I tried
thefollowing query </font><p class="MsoPlainText"><font size="3"> </font><p class="MsoPlainText"><font size="3">explain
select* </font><p class="MsoPlainText"><font size="3">from t1, t2, t3 </font><p class="MsoPlainText"><font
size="3">wheret1.f <= t2.f</font><p class="MsoPlainText"><font size="3"><span style=""> </span>and t2.f <=
t3.f</font><pclass="MsoPlainText"><font size="3"><span style=""> </span>and t1.f <= t3.f;</font><p
class="MsoPlainText"><fontsize="3"> </font><p class="MsoPlainText"><font size="3">And that's what I got:</font><p
class="MsoPlainText"><fontsize="3"> </font><p class="MsoPlainText"><font size="3">Nested Loop<span style="">
</span>(cost=0.00..3.15rows=1 width=368)</font><p class="MsoPlainText"><font size="3"><span style=""> </span>Join
Filter:(("outer".f <= "inner".f) AND ("inner".f <= "outer".f))</font><p class="MsoPlainText"><font size="3"><span
style=""> </span>-><span style=""> </span>Nested Loop<span style=""> </span>(cost=0.00..2.10 rows=1
width=218)</font><pclass="MsoPlainText"><font size="3"><span style=""> </span>Join Filter: ("outer".f <=
"inner".f)</font><pclass="MsoPlainText"><font size="3"><span style=""> </span>-><span style=""> </span>Seq
Scanon t1<span style=""> </span>(cost=0.00..1.01 rows=1 width=146)</font><p class="MsoPlainText"><font size="3"><span
style=""> </span>-><span style=""> </span>Seq Scan on t3<span style=""> </span>(cost=0.00..1.04 rows=4
width=72)</font><pclass="MsoPlainText"><font size="3"><span style=""> </span>-><span style=""> </span>Seq Scan on
t2<spanstyle=""> </span>(cost=0.00..1.02 rows=2 width=150)</font><p class="MsoPlainText"><font size="3"><span
style="color:black;"> </span></font><p class="MsoPlainText"><font size="3"><span style="color:
black;"> </span></font><pclass="MsoPlainText"><font size="3"><span style="color: black;">I was wondering if there is a
wayto omit the redundant join predicate.</span></font><p class="MsoPlainText"><font size="3"><span style="color:
black;"> </span></font><pclass="MsoPlainText"><font size="3"><span style="color: black;">Thanks,</span></font><p
class="MsoPlainText"><fontsize="3"><span style="color: black;">--h</span></font></div><br /><hr />Windows Live Hotmail
andMicrosoft Office Outlook – together at last. <a
href="http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=CL100626971033"target="_new">Get it now!</a>
