Re: Outer Joins - Mailing list pgsql-general

From Robert B. Easter
Subject Re: Outer Joins
Date
Msg-id 01010620195818.09559@comptechnews
Whole thread Raw
In response to Re: Outer Joins  ("Poul L. Christiansen" <poulc@cs.auc.dk>)
Responses Re: Outer Joins
Re: Outer Joins
List pgsql-general
What is the syntax for this?  Is there an example I can see/run?

On Thursday 04 January 2001 04:30, Poul L. Christiansen wrote:
> 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

--
-------- Robert B. Easter  reaster@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------

pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: backend corruption
Next
From: "Robert B. Easter"
Date:
Subject: Re: Passing tables as parameter