Re: New notices?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: New notices?
Дата
Msg-id 199909291539.LAA01831@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: New notices?  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список pgsql-hackers
> > > I updated my current tree and now this message comes out on even
> > > simple queries. Is it supposed to be there? If so, why??
> > Strange.  I don't get it:
>
> I'll bet it is coming from my using expandAll() to support the new
> join syntax, and as a kludge I am feeding it a dummy parse state as a
> placeholder. As I try to implement table and column aliases, I'll be
> mucking around in all of these areas. It isn't at all clear to me from
> the notes or from the checks that there was some specific case this
> was intended to catch...

This was added to address the long-standing error reports of problems
when addressing aliased and non-aliased columns in the same query.  We
don't issue an error, but go ahead and auto-create a from entry, very
non-standard SQL:

    SELECT tab.* FROM tab t

Tom Lane and I agreed we need to issue a NOTICE for this type of
auto-FROM creation.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


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

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] string function
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: New notices?