| From: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
|---|---|
| To: | "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>, Michael Dunn <michael(at)2cactus(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Outer Joins |
| Date: | 2001-01-07 01:19:58 |
| Message-ID: | 01010620195818.09559@comptechnews |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)comptechnews(dot)com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-07 01:21:31 | Re: Outer Joins |
| Previous Message | Brett W. McCoy | 2001-01-07 00:18:05 | Re: backend corruption |