Re: Getting non_NULL right-side values on a non-matching join? - Mailing list pgsql-general

From Tom Lane
Subject Re: Getting non_NULL right-side values on a non-matching join?
Date
Msg-id 1709.1385181722@sss.pgh.pa.us
Whole thread Raw
In response to Re: Getting non_NULL right-side values on a non-matching join?  (Ken Tanzer <ken.tanzer@gmail.com>)
Responses Re: Getting non_NULL right-side values on a non-matching join?
List pgsql-general
Ken Tanzer <ken.tanzer@gmail.com> writes:
> On Fri, Nov 22, 2013 at 8:04 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I found a less nasty workaround: if you replace "my_field" by
>> "foo.my_field" in the SELECT list of boo_top_view, the problem goes away.

> I'm happy to be of assistance, but mostly glad it wasn't a me-bug! :)  I
> put an alias on every field reference in the view, and the problem did
> indeed go away.  Thank you very much for providing an easy workaround!

Great, I'm glad that was good enough for you.  There's a real fix
committed here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=c0aa210f6ebab06ca3933c735c7c6d2b8bdd024e
but since you expressed some discomfort about patching source before,
it's probably best if you just work around it till we put out new
releases.

            regards, tom lane


pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Getting non_NULL right-side values on a non-matching join?
Next
From: Ken Tanzer
Date:
Subject: Re: Getting non_NULL right-side values on a non-matching join?