Re: deleting rows in specific order

At 04:14 PM 10/9/06, Daniel Drotos wrote:
>What is the best way to do something like:
>
>delete from tablename where something order by somefield...


You cannot, because it doesn't make sense.  The "order by" clause is not 
valid on delete statement.  Queries from other processes that start while 
your delete is running will either see all the deleted rows or (perhaps) 
they will see none of them.