From: | "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Delete/Update with ORDER BY |
Date: | 2007-10-25 12:50:02 |
Message-ID: | 15362F202C62EA4590F5F3E5FA15021E0528676A@nasappexc04.asurion.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
SQL> delete from a where a1 = 10 order by a2;
delete from a where a1 = 10 order by a2
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
Sure enough, it doesn't work. What are you trying to do with an order by on
a delete?
Jon
-----Original Message-----
From: Evandro Andersen [mailto:evandro_andersen2000(at)yahoo(dot)com(dot)br]
Sent: Thursday, October 25, 2007 7:25 AM
To: pgsql-general(at)postgresql(dot)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 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/
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Andy | 2007-10-25 14:08:44 | Re: Using Postgres as a "embedded" / SQL Lite database on Windows |
Previous Message | A. Kretschmer | 2007-10-25 12:44:45 | Re: Delete/Update with ORDER BY |