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

From Kevin Grittner
Subject Re: Getting non_NULL right-side values on a non-matching join?
Date
Msg-id 1385072532.16339.YahooMailNeo@web162904.mail.bf1.yahoo.com
Whole thread Raw
In response to 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> 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


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: corruption issue after server crash - ERROR: unexpected chunk number 0
Next
From: Joey Quinn
Date:
Subject: Re: Primary Key