Sam Mason wrote:
On Thu, Mar 19, 2009 at 04:22:56PM +0200, Peter Eisentraut wrote:
Joins nest from left to write, so
tbl_c NATURAL JOIN tbl_a NATURAL JOIN tbl_b
means
(tbl_c NATURAL JOIN tbl_a) NATURAL JOIN tbl_b
If you want a different order, you can set the parentheses differently,
with possibly different results.
When would you get different results? As far as I can tell, for INNER
joins, you'd always get the same thing back for any ordering. With
OUTER joins it obviously matters what's going on, but that's expected.
Right.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
