• Bruce Momjian's avatar
    The documentation for SELECT is incorrect in a sense: the syntax for a · 0fe77d72
    Bruce Momjian authored
    join is defined as:
    
    from_item [ NATURAL ] join_type from_item
        [ ON join_condition | USING ( join_column_list ) ]
    
    However, if the join_type is an INNER or OUTER join, an ON, USING, or
    NATURAL clause *must* be specified (it's not optional, as that segment
    of the docs suggest).
    
    I'm not exactly sure what the best way to fix this is, so I've attached
    a patch adding a FIXME comment to the relevant section of the SGML. If
    anyone has any ideas on the proper way to outline join syntax, please
    speak up.
    
    Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
    0fe77d72
select.sgml 42.4 KB