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