"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