Re: deleting rows in specific order

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Daniel Drotos <drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: deleting rows in specific order
Date: 2006-10-11 12:48:26
Message-ID: 452CE81A.5010001@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Drotos 2006-10-11 19:31:37 Re: deleting rows in specific order
Previous Message Markus Schaber 2006-10-11 12:31:57 Re: optimal insert