DELETE – remove objects from a database.
[ WITH with-item [, ...] ] DELETE expr [ FILTER filter-expr ] [ ORDER BY order-expr [direction] [THEN ...] ] [ OFFSET offset-expr ] [ LIMIT limit-expr ] ;
WITHclause allows specifying module aliases as well as expression aliases that can be referenced by the
DELETEstatement. See WITH block for more information.
- DELETE ...
The entire DELETE ... statement is syntactic sugar for
DELETE (SELECT ...). Therefore, the base expr and the following FILTER, ORDER BY, OFFSET, and LIMIT clauses shape the set to be deleted the same way an explicit SELECT would.