Re: deleting rows in specific order - Mailing list pgsql-sql

From Frank Bax
Subject Re: deleting rows in specific order
Date
Msg-id 5.2.1.1.0.20061009175632.057feec0@pop6.sympatico.ca
Whole thread Raw
In response to deleting rows in specific order  (Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu>)
List pgsql-sql
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. 



pgsql-sql by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)
Next
From: Josh Berkus
Date:
Subject: Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)