Re: Efficient DELETE Strategies

Manfred Koizar <mkoi-pg@aon.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