Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 37A814761BF for ; Fri, 13 Sep 2002 08:10:24 -0400 (EDT) Received: from mailgate5.cinetic.de (mailgate5.cinetic.de [217.72.192.165]) by postgresql.org (Postfix) with ESMTP id 089DA476003 for ; Fri, 13 Sep 2002 08:10:23 -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 g8DCAPX06979 for pgsql-sql@postgresql.org; Fri, 13 Sep 2002 14:10:25 +0200 Date: Fri, 13 Sep 2002 14:10:25 +0200 Message-Id: <200209131210.g8DCAPX06979@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/132 X-Sequence-Number: 9409 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 ______________________________________________________________________________ Die clevere Geldreserve: der DiBa-Privatkredit. Funktioniert wie ein Dispo, ist aber viel gunstiger! Alle Infos: http://diba.web.de/?mc=021104