From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dean Gibson (DB Administrator) <postgresql4@ultimeth.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: What does "merge-joinable join conditions" mean ????
Date: Sun, 15 Jan 2006 19:10:18 -0500
Message-ID: <24607.1137370218@sss.pgh.pa.us> (raw)
In-Reply-To: <43CADF2C.7010100@ultimeth.com>
References: <43CAAFA6.6050001@ultimeth.com>
<20060115215448.GA30809@winnie.fuhr.org>
<43CACC78.7090107@ultimeth.com>
<24299.1137367313@sss.pgh.pa.us>
<43CADB44.70309@ultimeth.com>
<24424.1137368560@sss.pgh.pa.us>
<43CADF2C.7010100@ultimeth.com>
"Dean Gibson (DB Administrator)" <postgresql4@ultimeth.com> writes:
> So, given the fact that the right-hand-table is only about 15 rows, do
> you think changing the SELECT back to a LEFT JOIN, and then using a
> UNION to get the extra right-hand-rows in, is the best work-around?
Yeah, a UNION of left and right joins seems the only very reasonable
solution. As long as you're sure there are no duplicate rows you
need to keep, it'll work well enough.
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, postgresql4@ultimeth.com
Subject: Re: What does "merge-joinable join conditions" mean ????
In-Reply-To: <24607.1137370218@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