Re: Request for qualified column names

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Request for qualified column names
Дата
Msg-id 26547.1043680870@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Request for qualified column names  ("Reggie Burnett" <rykr@bellsouth.net>)
Ответы Re: Request for qualified column names  ("Reggie Burnett" <rykr@bellsouth.net>)
Re: Request for qualified column names  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
"Reggie Burnett" <rykr@bellsouth.net> writes:
> When talking about expressions,views, or any other construct that could
> combine values from multiple tables I think it is reasonable to provide
> null as the table name.  Any one or any process requesting the table
> name has to understand that not all SQL parameters have a base table
> name.  However, in the case where a single table is involved, table and
> schema names should be available.

That seems quite pointless.  You hardly need the backend's help to
determine which column belongs to which table in a single-table query.
AFAICS this facility is only of interest if it does something useful
in not-so-trivial cases.
        regards, tom lane


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

Предыдущее
От: Antti Haapala
Дата:
Сообщение: Re: Switching connection on the fly
Следующее
От: Antti Haapala
Дата:
Сообщение: Re: Switching connection on the fly