Re: deleting rows in specific order

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: deleting rows in specific order
Дата
Msg-id 452CE81A.5010001@logix-tt.com
обсуждение исходный текст
Ответ на deleting rows in specific order  (Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu>)
Ответы Re: deleting rows in specific order  (Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu>)
Список 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 по дате отправления:

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: optimal insert
Следующее
От: Daniel Drotos
Дата:
Сообщение: Re: deleting rows in specific order