Re: NATURAL JOINs - Mailing list pgsql-general

From Scott Marlowe
Subject Re: NATURAL JOINs
Date
Msg-id dcc563d10810151127w51b0b84cx40bc67a7780faf98@mail.gmail.com
Whole thread Raw
In response to Re: NATURAL JOINs  ("Richard Broersma" <richard.broersma@gmail.com>)
Responses Re: NATURAL JOINs  (Marco Colombo <pgsql@esiway.net>)
List pgsql-general
On Wed, Oct 15, 2008 at 10:17 AM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> On Wed, Oct 15, 2008 at 9:03 AM, Reg Me Please <regmeplease@gmail.com> wrote:
>
>> Both are perfectly right, indeed.
>> Nonetheless, in my opinion a NATURAL JOIN  exploiting the FKs
>> instead of the column names would be much more helpful and much less error
>> prone!
>>
>> As far as I know there is no way to exploit FKs in JOINs, right?
>
> Yes AFAIK, this would make postgresql's implementation of natural join
> violate the SQL standard.  Perhaps you could propose an "UNNATURAL
> JOIN" syntax extension. ;)

Or a "VERY VERY NATURAL JOIN" syntax?  :)

pgsql-general by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: Drupal and PostgreSQL - performance issues?
Next
From: "Scott Marlowe"
Date:
Subject: slony and fill factor