Re: BUG #12000: "CROSS JOIN" not equivalent to ","

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: BUG #12000: "CROSS JOIN" not equivalent to ","
Дата
Msg-id CAKFQuwaWZVxB0-c0xwcNBGJL2tLuYyZ=c8YsLhK5QeuV-d83_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #12000: "CROSS JOIN" not equivalent to ","  ("Dr. Andreas Kunert" <kunert@cms.hu-berlin.de>)
Ответы Re: BUG #12000: "CROSS JOIN" not equivalent to ","  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Wed, Nov 19, 2014 at 5:21 AM, Dr. Andreas Kunert <kunert@cms.hu-berlin.d=
e
> wrote:

> On 18.11.2014 18:55, Tom Lane wrote:
> > I don't think it's the place of the manual to be prescriptive about
> style;
> > at least, not here.
> >
> > We could do something like "<CROSS JOIN example> is equivalent to <INNE=
R
> JOIN ON
> > TRUE example>.  <CROSS JOIN example> is also equivalent to <example wit=
h
> > comma>, but in cases with more than two tables this equivalence is not
> > exact, because JOIN binds more tightly than comma."
>

Instead of embedding this in the CROSS JOIN section why not put the
additional information at the top of the subsection since it does apply to
all of the join types.

After:

"A joined table is a table derived from two other (real or derived) tables
[...] cross-joins are available."

add something like:

"When explicit joins are mixed in with the comma-list the joins bind more
tightly than the commas."

David J.=E2=80=8B

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Dr. Andreas Kunert"
Дата:
Сообщение: Re: BUG #12000: "CROSS JOIN" not equivalent to ","
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #12000: "CROSS JOIN" not equivalent to ","