From: Bruno Wolff III <bruno@wolff.to>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: " Adding missing FROM-clause entry for table .... " problem.
Date: Tue, 18 Feb 2003 08:12:43 -0600
Message-ID: <20030218141243.GA11505@wolff.to> (raw)
In-Reply-To: <3E521E3F.C5E4251B@rodos.fzk.de>
References: <3E521E3F.C5E4251B@rodos.fzk.de>
On Tue, Feb 18, 2003 at 12:51:27 +0100,
Christoph Haller <ch@rodos.fzk.de> wrote:
> AFAIK, statements like
>
> DELETE FROM t1 where t1.id = t2.id ;
>
> are legal. Could the parser still work on this, if the feature is
> removed?
Only if a new syntax is added.
In fact it would be nice if this automatic adding of join tables was documented
under delete. Most people aren't going to notice that the optional listing
of joined tables mentioned under the select documenation applies to delete.
And if people don't notice they are likely to try to implement this using
subselects which may not be as efficient in some cases.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, ch@rodos.fzk.de
Subject: Re: " Adding missing FROM-clause entry for table .... " problem.
In-Reply-To: <20030218141243.GA11505@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox