Re: Outer Joins

PostgreSQL 7.1 (which is in beta now) will have outer joins.

It will probably (and hopefully) be released in Jan./Feb., but the beta
seems quite stable to me.

Poul L. Christiansen

Michael Dunn wrote:

> I am relatively new to the list and somewhat new to PostgreSQL.  I am
> wondering if there has been any discussion or thought about including
> outer joins in later releases of PostreSQL.  It seems highly inefficient
> simulating outer joins with subqueries and UNION ALL statements.  Or,
> perhaps PostgreSQL has another way prevent unjoined rows from being
> supressed in the results.  Your comments are welcome.
>
> Thanks, Micael Dunn