From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Zeugswetter Andreas <andreas(dot)zeugswetter(at)telecom(dot)at>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Re: [SQL] aliases break my query |
Date: | 2000-05-26 23:43:12 |
Message-ID: | 200005262343.TAA02242@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
> "Zeugswetter Andreas" <andreas(dot)zeugswetter(at)telecom(dot)at> writes:
> > I think we could get agreement to not allow implicit from entries
> > if there is a from clause in the statement, but allow them if a from clause
> > is missing altogether. The patch did not distinguish the two cases.
>
> Hmm, that's a thought. Taking it a little further, how about this:
>
> "Emit a notice [or error if you insist] when an implicit FROM item is
> added that refers to the same underlying table as any existing FROM
> item."
>
> 95% of the complaints I can remember seeing were from people who got
> confused by the behavior of "FROM table alias" combined with a reference
> like "table.column". Seems to me the above rule would catch this case
> without being obtrusive in the useful cases. Comments?
Yes, I even added a define called FROM_WARN. It was disabled, and never
enabled. When can we enable it?
--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2000-05-26 23:59:08 | Re: where is libpq-fe.h |
Previous Message | Bruce Momjian | 2000-05-26 23:41:44 | Re: Berkeley DB... |
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2000-05-27 01:45:07 | Re: Re: [SQL] aliases break my query |
Previous Message | Tom Lane | 2000-05-26 22:48:04 | Re: [SQL] is limit a reserved keyword? |