Re: What does "merge-joinable join conditions" mean ????

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dean Gibson (DB Administrator)" <postgresql4(at)ultimeth(dot)com>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: What does "merge-joinable join conditions" mean ????
Date: 2006-01-16 00:10:18
Message-ID: 24607.1137370218@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Dean Gibson (DB Administrator)" <postgresql4(at)ultimeth(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel CAUNE 2006-01-16 10:35:47 Executing plpgsql scripts using psql, is that possible?
Previous Message Dean Gibson (DB Administrator) 2006-01-15 23:47:56 Re: What does "merge-joinable join conditions" mean ????