Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 433F447595A for ; Wed, 12 Jun 2002 10:04:20 -0400 (EDT) Received: from email01.aon.at (WARSL402PIP3.highway.telekom.at [195.3.96.97]) by postgresql.org (Postfix) with SMTP id D029747585D for ; Wed, 12 Jun 2002 10:04:18 -0400 (EDT) Received: (qmail 421750 invoked from network); 12 Jun 2002 14:04:17 -0000 Received: from m156p012.dipool.highway.telekom.at (HELO cantor) ([62.46.9.108]) (envelope-sender ) by qmail1rs.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 12 Jun 2002 14:04:17 -0000 From: Manfred Koizar To: Tom Lane Cc: Christoph Haller , pgsql-sql@postgresql.org Subject: Re: Efficient DELETE Strategies Date: Wed, 12 Jun 2002 16:03:39 +0200 Message-ID: References: <200206110918.LAA20463@rodos> <18946.1023805720@sss.pgh.pa.us> In-Reply-To: <18946.1023805720@sss.pgh.pa.us> X-Mailer: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/147 X-Sequence-Number: 8112 On Tue, 11 Jun 2002 10:28:40 -0400, Tom Lane wrote: >It would seem that > > DELETE [ FROM ] relation_expr [ alias_clause ] > [ FROM from_list ] where_clause > >is the syntax that would be most nearly compatible with MSSQL and MySQL. >Does Oracle have anything comparable? Oracle basically supports (with slight variations between releases 7/8/9): DELETE [FROM] { table | view | ( subquery ) } [alias] [WHERE ...] [returning_clause] Informix (March 1997, 9.1?): DELETE FROM { table | ONLY ( table ) | view | synonym | collection_derived_table } WHERE condition According to the "SQL Quick Syntax Guide" the WHERE clause is not optional. Does anybody know, if this is a documentation bug? "Guide to SQL, Syntax" (Feb 1998, v7.3, v8.2) says, the WHERE clause is optional, as we'd expect. Servus Manfred