Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Fields re-ordered on JOIN with * and USING - Mailing list pgsql-general

From Ken Tanzer
Subject Re: [GENERAL] Fields re-ordered on JOIN with * and USING
Date
Msg-id CAD3a31XdoGO_9LgF=G92e=KQF3ThcWKeBQvyb5UYyqD5-cD9XA@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Fields re-ordered on JOIN with * and USING  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
...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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Fields re-ordered on JOIN with * and USING
Next
From: Олег Самойлов
Date:
Subject: [GENERAL] Numeric numbers