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

From Markus Schaber
Subject Re: deleting rows in specific order
Date
Msg-id 452CE81A.5010001@logix-tt.com
Whole thread Raw
In response to deleting rows in specific order  (Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu>)
Responses Re: deleting rows in specific order  (Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu>)
List pgsql-sql
Hi, Daniel,

Daniel Drotos wrote:

> What is the best way to do something like:
> 
> delete from tablename where something order by somefield...

There should be no need for this, because a delete is atomic due to the
transaction system.


What is it that you're trying to achieve with the ordered delete? Maybe
there's a better way to solve your underlying problem.


HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org


pgsql-sql by date:

Previous
From: Markus Schaber
Date:
Subject: Re: optimal insert
Next
From: Daniel Drotos
Date:
Subject: Re: deleting rows in specific order