On Wed, Oct 15, 2008 at 10:17 AM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > On Wed, Oct 15, 2008 at 9:03 AM, Reg Me Please <regmeplease@xxxxxxxxx> 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? :) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general