referring to calculated column in sub select

Поиск
Список
Период
Сортировка
От Scara Maccai
Тема referring to calculated column in sub select
Дата
Msg-id 774626.9811.qm@web24615.mail.ird.yahoo.com
обсуждение исходный текст
Ответы Re: referring to calculated column in sub select  (Sam Mason <sam@samason.me.uk>)
Re: referring to calculated column in sub select  (Scott Bailey <artacus@comcast.net>)
Список pgsql-general
Hi,

why column "acoltest" is not found by the subselect in this select:


SELECT
      acol + 100 as acoltest,
     (select max(t) from mytab where anothercol=acoltest) as col2
FROM mytab2
group by somet
???
Only columns belonging to a table can be used in a subselect??? What about "calculated" columns?
Thank you




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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Need help
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is this a bug or a feature? Column visibility in subquery from outer query