Re: [GENERAL] Fields re-ordered on JOIN with * and USING

Поиск
Список
Период
Сортировка
От Ken Tanzer
Тема Re: [GENERAL] Fields re-ordered on JOIN with * and USING
Дата
Msg-id CAD3a31XdoGO_9LgF=G92e=KQF3ThcWKeBQvyb5UYyqD5-cD9XA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Fields re-ordered on JOIN with * and USING  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
...least excruciating version of the relevant text...

Ouch, I'm glad you folks take care of reading such stuff!  What you put in the documentation was much much clearer--just wish I had found it!

Speaking of which, I had looked at the "From" section of the "SELECT" page (https://www.postgresql.org/docs/current/static/sql-select.html#SQL-FROM), which also has a somewhat detailed section on joins.  I'm wondering about the utility of:

  • Adding a link from the "SELECT" page (FROM section) to the page Tom referenced (which includes a link the other way)
and/or
  • Adding this detail to the section on USING on the select page:

A clause of the form USING ( a, b, ... ) is shorthand for ON left_table.a = right_table.a AND left_table.b = right_table.b .... Also, USING implies that only one of each pair of equivalent columns will be included in the join output, not both.  Outcome columns specified by USING will appear first in the joined results.

Cheers,
Ken

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Fields re-ordered on JOIN with * and USING
Следующее
От: Олег Самойлов
Дата:
Сообщение: [GENERAL] Numeric numbers