Ken Tanzer <ken.tanzer@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
