Re: Efficient DELETE Strategies

Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> Oracle basically supports (with slight variations between releases
> 7/8/9):
> DELETE [FROM] { table
> | view
> | ( subquery )
> }
> [alias] [WHERE ...] [returning_clause]

Bizarre. How are you supposed to delete from a subquery?

> According to the "SQL Quick Syntax Guide" the WHERE clause is not
> optional. Does anybody know, if this is a documentation bug?

Probably. SQL92 saith:

<delete statement: searched> ::=
DELETE FROM <table name>
[ WHERE <search condition> ]

<delete statement: positioned> ::=
DELETE FROM <table name>
WHERE CURRENT OF <cursor name>

so I could see where a sloppy reader might get confused...

regards, tom lane