Re: Outer Joins - Mailing list pgsql-general

From Robert B. Easter
Subject Re: Outer Joins
Date
Msg-id 0101071407201E.09559@comptechnews
Whole thread Raw
In response to Re: Outer Joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Outer Joins  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sunday 07 January 2001 13:13, Tom Lane wrote:
> "Robert B. Easter" <reaster@comptechnews.com> writes:
> > UNION JOIN is deprecated
>
> Oh?  By whom?
>
> The reason 7.1 doesn't have it is I didn't have time for it, not that
> we don't plan to do it ever.

I read it in the SQL spec.  ANSI/ISO 9075-2 1999 (final).

                                       Annex D

                                    (informative)

                                 Deprecated features



         It is intended that the following features will be removed at a
         later date from a revised version of this part of ISO/IEC 9075:

         1) The ability to specify UNION JOIN in a <joined table> has been
            deprecated.

It's the only one.  I sent a patch to the patches list for JOIN
documentation.  In it, the only thing I said about UNION JOIN is
"Deprecated."  Let me know if I should change that.  I thought about omitting
it entirely.

--
-------- 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: Tom Lane
Date:
Subject: Re: cyrillic and sort order (ORDER BY)
Next
From: Tom Lane
Date:
Subject: Re: Outer Joins