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. ;) -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
