Skip to content
Snippets Groups Projects
  • Tom Lane's avatar
    d767aa51
    Improve documentation's description of JOIN clauses. · d767aa51
    Tom Lane authored
    In bug #12000, Andreas Kunert complained that the documentation was
    misleading in saying "FROM T1 CROSS JOIN T2 is equivalent to FROM T1, T2".
    That's correct as far as it goes, but the equivalence doesn't hold when
    you consider three or more tables, since JOIN binds more tightly than
    comma.  I added a <note> to explain this, and ended up rearranging some
    of the existing text so that the note would make sense in context.
    
    In passing, rewrite the description of JOIN USING, which was unnecessarily
    vague, and hadn't been helped any by somebody's reliance on markup as a
    substitute for clear writing.  (Mostly this involved reintroducing a
    concrete example that was unaccountably removed by commit 032f3b7e.)
    
    Back-patch to all supported branches.
    d767aa51
    History
    Improve documentation's description of JOIN clauses.
    Tom Lane authored
    In bug #12000, Andreas Kunert complained that the documentation was
    misleading in saying "FROM T1 CROSS JOIN T2 is equivalent to FROM T1, T2".
    That's correct as far as it goes, but the equivalence doesn't hold when
    you consider three or more tables, since JOIN binds more tightly than
    comma.  I added a <note> to explain this, and ended up rearranging some
    of the existing text so that the note would make sense in context.
    
    In passing, rewrite the description of JOIN USING, which was unnecessarily
    vague, and hadn't been helped any by somebody's reliance on markup as a
    substitute for clear writing.  (Mostly this involved reintroducing a
    concrete example that was unaccountably removed by commit 032f3b7e.)
    
    Back-patch to all supported branches.