Re: [GENERAL] Delete/Update with order by

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

Re: [GENERAL] Delete/Update with order by

On 10/25/07, Evandro Andersen <[EMAIL PROTECTED]> wrote: > In Oracle you can use this: > > DELETE FROM A WHERE A1 = 10 ORDER BY A2 > > There is something in the Postgresql ? That doesn't work in Oracle 9i, I tried it. No, there's nothing exactly like it in pgsql. ---(end

[GENERAL] Delete/Update with order by

In Oracle you can use this: DELETE FROM A WHERE A1 = 10 ORDER BY A2 There is something in the Postgresql ? Evandro Andersen Brazil Postgresql 8.2 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Delete/Update with ORDER BY

iginal Message- From: Evandro Andersen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 7:25 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Delete/Update with ORDER BY In Oracle you can use this: DELETE FROM A WHERE A1 = 10 ORDER BY A2 There is something in the Postgresq

Re: [GENERAL] Delete/Update with ORDER BY

am Thu, dem 25.10.2007, um 5:25:14 -0700 mailte Evandro Andersen folgendes: > In Oracle you can use this: > > > > DELETE FROM A WHERE A1 = 10 ORDER BY A2 > > > > There is something in the Postgresql ? Can you explain this a little bit more? I can't see any sense. Either i delete rows with

[GENERAL] Delete/Update with ORDER BY

In Oracle you can use this: DELETE FROM A WHERE A1 = 10 ORDER BY A2 There is something in the Postgresql ? Evandro Andersen Brazil Postgresql 8.2 Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/ ---