Re: Strange left join problems in 8.1

<p><font size="2">I've tried this with cvs , -r REL8_1_STABLE (hope this was the right one), and works flawless now.<br
/><br/> Thanks a lot!<br /><br /> Best regards<br /> Mario Weilguni<br /><br /><br /> -----Ursprüngliche
Nachricht-----<br/> Von: Tom Lane [<a href="mailto:tgl@sss.pgh.pa.us">mailto:tgl@sss.pgh.pa.us</a>]<br /> Gesendet: Sa
03.12.200517:53<br /> An: Mario Weilguni<br /> Cc: pgsql-hackers@postgresql.org<br /> Betreff: Re: [HACKERS] Strange
leftjoin problems in 8.1<br /><br /> "Mario Weilguni" <mario.weilguni@icomedias.com> writes:<br /> > It seems
likethe planner is pulling the last where condition into the<br /> > second left join, evaluating it in wrong
order.<br/><br /> Can you try this on 8.1 branch tip?  It sounds suspiciously similar to<br /> an already-fixed issue
(seereports from Sebastian Böck around<br /> mid-November).  You haven't provided a complete test case so I really<br
/>can't investigate for myself ...<br /><br />                         regards, tom lane<br /><br /></font>