From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <gsstark@mit.edu>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: Correia, Carla <Carla.Correia@logicacmg.com>
Cc: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: Complex outer joins?
Date: Thu, 27 Mar 2003 01:18:19 -0500
Message-ID: <9388.1048745899@sss.pgh.pa.us> (raw)
In-Reply-To: <878yv1l981.fsf@stark.dyndns.tv>
References: <20030326145855.J66362-100000@megazone23.bigpanda.com>
<878yv1l981.fsf@stark.dyndns.tv>
Greg Stark <gsstark@mit.edu> writes:
> Yeah, that's not a particularly enlightening case because if you convert the
> right joins to left joins you see that these aren't actually similar queries
> at all.
> the first is
> "C left join (G left join L)"
> and the second is
> "G left join (C left join L)"
> They only look similar superficially when written using right joins but
> they're actually totally different structures.
Yup, you're quite right. What's bothering me is that AFAICS they are
extremely similar in the Oracle notation too: put the (*) on the other
side of one of the equality clauses, and you convert one case to the
other. So how can you assert that Oracle's notation is not sensitive
to join order?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, gsstark@mit.edu, sszabo@megazone23.bigpanda.com, Carla.Correia@logicacmg.com
Subject: Re: Complex outer joins?
In-Reply-To: <9388.1048745899@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox