Andrew Dunstan <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
