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

Ken Tanzer <ken.tanzer@gmail.com> wrote:

> In doing a left join with a particular view as the right table,
> and non-matching join criteria, I am getting values returned in a
> few fields.  All the rest are NULL.  I would expect all the right
> side values to be NULL.

What is the output of executing?:

SELECT version();

There used to be some bugs in this area, but they should be fixed
in the current releases, AFAIK.

http://www.postgresql.org/support/versioning/

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company