Re: Cartesian product bug? - Mailing list pgsql-general

From scott.marlowe
Subject Re: Cartesian product bug?
Date
Msg-id Pine.LNX.4.33.0311031040510.25850-100000@css120.ihs.com
Whole thread Raw
In response to Re: Cartesian product bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Cartesian product bug?  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
On Fri, 31 Oct 2003, Tom Lane wrote:

> (Personally I think NATURAL JOIN is an evil, bug-prone construct,
> precisely because coincidental matches of column names will mess up your
> results.)

Me too.  When I first saw it, I figured it would "naturally join" the two
tables on their fk/pk relation if there was one.  That seems natural.
Joining on two fields that just happen to have the same name is unnatural
to me.


pgsql-general by date:

Previous
From: Alexandr S
Date:
Subject: question
Next
From: javier garcia - CEBAS
Date:
Subject: transposed query?