Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux