Re: Outer Joins

On Sunday 07 January 2001 13:13, Tom Lane wrote:
> "Robert B. Easter" <reaster(at)comptechnews(dot)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(at)comptechnews(dot)com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------