Re: psql 7.3.4 disagrees with NATURAL CROSS JOIN

Tom Lane wrote:

>Andrew Dunstan <andrew(at)dunslane(dot)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