Misa Simic <misa.simic@xxxxxxxxx> writes: > Yes you are right... I wanted: t1 left join (t2 inner join t3) > Is there a way to "say" that? Sure, just add the parentheses. t1 left join (t2 inner join t3 on t2-t3-condition) on t1-t2-condition > I mean to me, it is logical and without > brackets... i.e. t1 left join t2 inner join t3 left join t4, I would read > as: t1 left join (t2 inner join t3) left join t4 .... (Like INNER has > advantage on OUTER...)... Well, that might or might not be more intuitive, but the SQL standard says these bind equally, left to right, unless you use parens. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
