Re: Outer Joins

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/ ------------