On Wed, Oct 15, 2008 at 10:17 AM, Richard Broersma <[EMAIL PROTECTED]> wrote: > On Wed, Oct 15, 2008 at 9:03 AM, Reg Me Please <[EMAIL PROTECTED]> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general