Re: Multiple natural joins

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Thom Brown <thombrown(at)gmail(dot)com>
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multiple natural joins
Date: 2009-03-19 12:27:08
Message-ID: dcc563d10903190527i4f9dc533t513ca8dfcf0ed05e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 19, 2009 at 5:24 AM, Thom Brown <thombrown(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-03-19 12:35:03 Re: deadlock problem
Previous Message Joachim Tranvåg 2009-03-19 11:38:13 Re: (0x0000274D/10061) on Install