This
Hannu Krosing wrote:
> DELETE relation_expr FROM relation_expr [ , table_ref [ , ... ] ]
> [ WHERE bool_expr ]
This in some ways is similar to Oracle where the FROM is optional in a
DELETE (ie. DELETE foo WHERE ...). By omitting the first FROM, the
syntax ends up mirroring the UPDATE case:
DELETE foo FROM bar WHERE ...
UPDATE foo FROM bar WHERE ...
However I think the syntax should also support the first FROM as being
optional (even though it looks confusing):
DELETE FROM foo FROM bar WHERE ...
thanks,
--Barry