On Wed, Dec 30, 2009 at 1:43 PM, APseudoUtopia <apseudouto...@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?
