Re: Re: [SQL] aliases break my query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: [SQL] aliases break my query
Дата
Msg-id 3661.959376868@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [SQL] aliases break my query  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: [SQL] aliases break my query  (Peter Eisentraut <peter_e@gmx.net>)
Re: Re: [SQL] aliases break my query  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Re: [SQL] aliases break my query  (Andreas Zeugswetter <andreas.zeugswetter@telecom.at>)
Список pgsql-hackers
"Zeugswetter Andreas" <andreas.zeugswetter@telecom.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?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: Berkeley DB...
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Re: [SQL] aliases break my query