Shouldn't Natural JOINs Follow FK Constraints? - Mailing list pgsql-hackers

From David E. Wheeler
Subject Shouldn't Natural JOINs Follow FK Constraints?
Date
Msg-id 5A9D2F88-ED44-43EA-B820-4EA210F645C7@justatheory.com
Whole thread Raw
Responses Re: Shouldn't Natural JOINs Follow FK Constraints?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Howdy,

I just saw this in the docs:

> Finally, NATURAL is a shorthand form of USING: it forms a USING list  
> consisting of exactly those column names that appear in both input  
> tables. As with USING, these columns appear only once in the output  
> table.

That sounds useful if I happen to have named my columns exactly the  
same between the two tables, but couldn't a NATURAL JOIN follow the FK  
constraints, instead? That would be so much more useful and much less  
magical, I should think.

Thanks,

David


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Core team statement on replication in PostgreSQL
Next
From: Robert Treat
Date:
Subject: Re: Core team statement on replication in PostgreSQL