Re: NATURAL JOINs

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. ;)


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug