Re: Is this a bug or a feature? Column visibility in subquery from outer query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is this a bug or a feature? Column visibility in subquery from outer query
Дата
Msg-id 29685.1242656877@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Is this a bug or a feature? Column visibility in subquery from outer query  (Paolo Saul <paolo.saul@telogis.com>)
Ответы Re: Is this a bug or a feature? Column visibility in subquery from outer query
Список pgsql-general
Дерево обсуждения 
Paolo Saul <paolo.saul@telogis.com> writes:
> I just want to point out that the sub-query is using a column from the outer
> query (eg. x1)  without an alias from the table in the outer query.

This behavior is required by the SQL standard.  It's called an outer
reference.

            regards, tom lane

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

Предыдущее
От: Scara Maccai
Дата:
Сообщение: referring to calculated column in sub select
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump and 2gb limit on windows and version 8.1.3