Re: psql 7.3.4 disagrees with NATURAL CROSS JOIN

Tom Lane wrote:

>Andrew Dunstan <andrew@dunslane.net> writes:
>  
>
>>During the irc discussion I discovered that. But the CREATE TABLE page 
>>in the docs appears to suggest that it is legal. That should be fixed.
>>    
>>
>
>Where exactly?  I see
>
>  For the INNER and OUTER join types, a join condition must be specified,
>  namely exactly one of NATURAL, ON join_condition, or USING (join_column
>  [, ...]). See below for the meaning. For CROSS JOIN, none of these
>  clauses may appear.
>
>
>  
>

Dammit, I meant SELECT, from which you took that quote. And you're 
right. I missed that. Sorry.

I saw

from_item [ NATURAL ] join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ]

and then


join_type
   One of
       *
         [ INNER ] JOIN
       *
         LEFT [ OUTER ] JOIN
       *
         RIGHT [ OUTER ] JOIN
       *
         FULL [ OUTER ] JOIN
       *
         CROSS JOIN


I should have read further

cheers

andrew