Ken Tanzer <ken.tan...@gmail.com> writes: > Hello. 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.
Hmmm ... the join conditions involving COALESCE() remind me of a bug I just fixed last week. Are you in a position to try a patch? If so, here's the fix against 9.2: http://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=51b6ae6bba75bca2374a24cf7c740da74c955ad5 If that doesn't help, please see if you can extract a self-contained test case. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
