Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EACB447619B for ; Thu, 12 Sep 2002 11:57:40 -0400 (EDT) Received: from mailgate5.cinetic.de (mailgate5.cinetic.de [217.72.192.165]) by postgresql.org (Postfix) with ESMTP id E7D9A476072 for ; Thu, 12 Sep 2002 11:57:39 -0400 (EDT) Received: from web.de (fmomail02.dlan.cinetic.de [172.20.1.46]) by mailgate5.cinetic.de (8.11.2/8.11.2/SuSE Linux 8.11.0-0.4) with SMTP id g8CFviX31490 for pgsql-sql@postgresql.org; Thu, 12 Sep 2002 17:57:44 +0200 Date: Thu, 12 Sep 2002 17:57:44 +0200 Message-Id: <200209121557.g8CFviX31490@mailgate5.cinetic.de> MIME-Version: 1.0 Organization: http://freemail.web.de/ From: Hanno Wiegard To: pgsql-sql@postgresql.org Subject: Table alias in DELETE statements Precedence: fm-user Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/162 X-Sequence-Number: 9439 Hi, I've already checked the mailing archive but found nothing about problems with the DELETE statement and table alias but it's not mentioned in the docs. So the question for me is whether it is possible to use a table alias in a DELETE statement or not, e.g. DELETE FROM foo f WHERE f.ID > 3000 (more complicated cases in reality and I really need the alias because the SQL is generated automaically by a tool)? Thanks, Hanno Wiegard ______________________________________________________________________________ Wie ware das: mehrere E-Mail Adressen - aber nur ein Postfach ? Kein Problem mit WEB.DE FreeMail - http://freemail.web.de/?mc=021127