Re: Deleting 100 rows which meets certain criteria

On Wed, Dec 30, 2009 at 1:43 PM, APseudoUtopia <apseudoutopia(at)gmail(dot)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?