Re: AS operator and subselect result names: PostgreSQL

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: AS operator and subselect result names: PostgreSQL
Дата
Msg-id Pine.LNX.4.44.0311022209580.1528-100000@peter.localdomain
обсуждение исходный текст
Ответ на AS operator and subselect result names: PostgreSQL vs. Oracle  (nzanella@cs.mun.ca (Neil Zanella))
Список pgsql-general
Neil Zanella writes:

> 1. Does standard SQL allow an optional AS keyword for (re/)naming
>    tables including those resulting from subselects.

Yes.

> 2 Why must a subselect whose fields are referenced in an outer query
>   be explicitly named in PostgreSQL when it is not necessary in Oracle.

Because the SQL standard says so.

--
Peter Eisentraut   peter_e@gmx.net


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

Предыдущее
От: "mlunnon @ RWA"
Дата:
Сообщение: Re: Custom types and arrays
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: retrieve statement from catalogs