From: | Hanno Wiegard <hwiegard(at)web(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Table alias in DELETE statements |
Date: | 2002-09-12 15:57:44 |
Message-ID: | 200209121557.g8CFviX31490@mailgate5.cinetic.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-09-12 16:05:26 | Re: Performance inside and outside view ( WAS Re: Select the |
Previous Message | Gaetano Mendola | 2002-09-12 15:53:38 | Re: Performance inside and outside view ( WAS Re: Select the max on a field ) |