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
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
I have never seen order by in a delete statement in Oracle so I tested it.
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 25 07:45:50 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> create table a (a1 number, a2 number);
Table created
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
