Re: " Adding missing FROM-clause entry for table .... " problem.

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: " Adding missing FROM-clause entry for table .... " problem.
Date: 2003-02-18 16:03:10
Message-ID: 20030218160310.10141.qmail@web20801.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--- Tomasz Myrta <jasiek(at)klaster(dot)net> wrote:
> Christoph Haller wrote:
> <cut>
> > is not valid SQL syntax. What will actually happen
> (this is a PostgreSQL
> > extension to the standard) is that an implicit
> table
> > reference is added to the FROM clause, so the
> query is processed as if
> > it were written as
> I think this extension should be removed. I found
> all "Adding missing
> FROM..." were just results of mistake. Does anyone
> use this feature?
> What does other Postgres users think about it?
>

I want to add my vote for keeping the existing
functionality. I find it _very_ useful, especially
for interactive work. The spare syntax that can be
used for update or delete statements greatly enhances
understandability (and therefore reduces likelihood of
error) in my experience. Saves typing too :-)

I would not wish to reduce the functionality of
PostgreSQL just to save people from themselves.

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-02-18 16:06:42 Re: " Adding missing FROM-clause entry for table .... " problem.
Previous Message Tom Lane 2003-02-18 15:50:25 Re: " Adding missing FROM-clause entry for table .... " problem.