Re: Delete/Update with order by - Mailing list pgsql-general

From David Fetter
Subject Re: Delete/Update with order by
Date
Msg-id 20071031024347.GA10414@fetter.org
Whole thread Raw
In response to Delete/Update with order by  ("Evandro Andersen" <evandro.andersen@gmail.com>)
List pgsql-general
On Thu, Oct 25, 2007 at 09:22:02AM -0300, Evandro Andersen wrote:
> In Oracle you can use this:
>
> DELETE FROM A WHERE A1 = 10 ORDER BY A2
>
> There is something in the Postgresql ?

Yes.

DELETE...USING :)

http://www.postgresql.org/docs/current/static/sql-delete.html

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Laurent ROCHE
Date:
Subject: generating UPDATE SET ... WHERE PK = ...
Next
From: carter ck
Date:
Subject: