Re: Multiple natural joins - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Multiple natural joins
Date
Msg-id dcc563d10903190527i4f9dc533t513ca8dfcf0ed05e@mail.gmail.com
Whole thread Raw
In response to Multiple natural joins  (Thom Brown <thombrown@gmail.com>)
List pgsql-general
On Thu, Mar 19, 2009 at 5:24 AM, Thom Brown <thombrown@gmail.com> wrote:
> The confusion comes when 2 of those tables reference the 3rd table using the
> same column.
>
> So are natural joins only allowed to join 2 tables?  If not, how can it be
> used for more than 1 table has links to the other tables?

Not sure how well natural joins work on > 2 tables, but they are to be
avoided in my opinion.

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Multiple natural joins
Next
From: Tom Lane
Date:
Subject: Re: deadlock problem