Re: Strange left join problems in 8.1

I've tried this with cvs , -r REL8_1_STABLE (hope this was the right one), and works flawless now.

Thanks a lot!

Best regards
Mario Weilguni

-----Ursprüngliche Nachricht-----
Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Gesendet: Sa 03.12.2005 17:53
An: Mario Weilguni
Cc: pgsql-hackers(at)postgresql(dot)org
Betreff: Re: [HACKERS] Strange left join problems in 8.1

"Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com> writes:
> It seems like the planner is pulling the last where condition into the
> second left join, evaluating it in wrong order.

Can you try this on 8.1 branch tip? It sounds suspiciously similar to
an already-fixed issue (see reports from Sebastian Böck around
mid-November). You haven't provided a complete test case so I really
can't investigate for myself ...

regards, tom lane