Re: Getting non_NULL right-side values on a non-matching join?

Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> writes:
> Getting a build environment together seemed more painful, so here's a test
> case.

Wow, that's pretty broken. I'll dig into it tomorrow.

> Just for fun, I tried this in another database on a different
> machine (and with 9.0.08). I got the same results, so it doesn't seem to
> be a case of something wacky with my particular database.

Yeah, seems to fail the same way in all active branches ...

> p.s., Not your problem I know, but I need to deal with this somehow and
> rather soon.

If you just need a work-around-it-right-now solution, I'd suggest
introducing an "OFFSET 0" optimization fence into one or another of the
levels of view below the outer joins. I've not experimented but I think
that ought to fix it, at some possibly-annoying cost in query
optimization. Hopefully I'll have another answer tomorrow.

regards, tom lane