On Wed, Dec 30, 2009 at 1:43 PM, APseudoUtopia
<apseudoutopia@gmail.com> wrote:
You're correct to infer that DELETE does not support LIMIT clauses.
The reason for this is there is no way to tell exactly which rows will
be deleted (unless ORDER BY is used - but there are still other issues
with that as well).
You could, however, do something like such:
DELETE FROM "table" WHERE "column" IN (SELECT "column" FROM "table"
LIMIT 100 OFFSET 0);
(But again, you would need explicit ORDER BY clauses to determine
exactly which rows are actually deleted.
Are there any plans to disable that method as well, since it suffers from the same problem?
