Bruce Momjian wrote: It's been agreed that the keyword should
be USING, to avoid anything as confusing as DELETE FROM a FROM b.
FYI,
MSSQL says
DELETE
[FROM]
{tablename}
[FROM {<tablesource> [, ...] ]
[WHERE <condition>]
Note that the first FROM is optional (as in Oracle), we can have
DELETE a FROM b
The USING would be in place of the mandatory FROM in MSSQL. And why use a different keyword for the same thing in DELETE and UPDATE?
DELETE a FROM b UPDATE a FROM b DELETE FROM a USING b
Regards, Andreas
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
