Re: NATURAL JOINs

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?  :)