Re: Cartesian product bug?

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Åsmund Kveim Lie <asmundkl(at)skipthis(dot)ifi(dot)uio(dot)no>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cartesian product bug?
Date: 2003-11-03 17:41:44
Message-ID: Pine.LNX.4.33.0311031040510.25850-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Razvan Surdulescu 2003-11-03 18:16:31 Re: INSERT performance
Previous Message Harald Fuchs 2003-11-03 17:15:02 Re: Fixed field text import