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