Re: [SQL] Trouble with explicit joins

2004-10-21 Thread Dmitry Tkach
Tom Lane wrote: Dmitry Tkach <[EMAIL PROTECTED]> writes: I suppose, this is because the planner takes the order, in which the tables appear in the explicit joins as some kind of a hint to how I want that query to be executed, It's not a "hint", it's a requirement. In general, changing th

Re: [SQL] Trouble with explicit joins

2004-10-21 Thread Tom Lane
Dmitry Tkach <[EMAIL PROTECTED]> writes: > I suppose, this is because the planner takes the order, in which the > tables appear in the explicit joins as some kind of a hint to how I want > that query to be executed, It's not a "hint", it's a requirement. In general, changing the order in which

[SQL] Trouble with explicit joins

2004-10-21 Thread Dmitry Tkach
Hi, everybody! I am writing a fairly long query, that joins several (like 10-15) tables. It is dynamically generated, and the tables in the join may be different, depending on the criteria etc... The problem is that I need to outer (left) join some of those tables. The only way I know to do tha