pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Joseph Shraibman <jks@selectacast.net>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgreSQL.org>
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: aliases break my query
Date: Fri, 26 May 2000 12:26:06 -0400
Message-ID: <2392.959358366@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.GSO.4.02A.10005261453420.12244-100000@Falk.DoCS.UU.SE>
References: <Pine.GSO.4.02A.10005261453420.12244-100000@Falk.DoCS.UU.SE>

Peter Eisentraut <e99re41@DoCS.UU.SE> writes:
> Once again, I think that we *really* need to discuss whether implicit
> range table entries in SELECT are a good idea. We invariably get a
> question like this every week and invariably the answer is "if you give a
> table an alias you *must* refer to it by that alias". (I'm sure Tom has
> this reply automated by now.)

No, this one was actually a pretty original way of shooting oneself in
the foot ;-).  I thought the interesting point was the confusion between
whether variables in the inner select were supposed to be local to the
inner select or references to the outer select.  I'm not sure getting
rid of implicit rangetable entries would've helped prevent that.

> I claim the only thing that buys is
> confusion for very little convenience at the other end.
>
> Stop the madness! :)

I doubt that it's worth breaking a lot of existing applications for.

At one time Bruce had made some patches to emit informative notice
messages about implicit FROM entries, but that got turned off again
for reasons that I forget...

			regards, tom lane



view thread (15+ messages)  latest in thread

Message-ID: <2392.959358366@sss.pgh.pa.us>
Permalink:  ../2392.959358366@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2392.959358366@sss.pgh.pa.us

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, peter_e@gmx.net, jks@selectacast.net, pgsql-hackers@postgreSQL.org
  Subject: Re: aliases break my query
  In-Reply-To: <2392.959358366@sss.pgh.pa.us>
  References: <Pine.GSO.4.02A.10005261453420.12244-100000@Falk.DoCS.UU.SE> <2392.959358366@sss.pgh.pa.us>

* 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