subquery question
От
Tom Raney
Тема
subquery question
Дата
Msg-id
4984E91B.5010000@comcast.net
Список
Дерево обсуждения
subquery question Tom Raney <twraney@comcast.net>
Re: subquery question Richard Broersma <richard.broersma@gmail.com>
I've dug around on the Postgres lists for a bit and I haven't found a
good explanation of why this query is not allowed.
SELECT Temp.team_id, Temp.count_agents
FROM (SELECT TR.team_id, COUNT(TR.agent_id) AS count_agents
FROM teamrel TR
GROUP BY TR.team_id ) AS Temp
WHERE Temp.count_agents = (SELECT MIN (Temp.count_agents) FROM Temp)
I know that column aliases are not accessible in the WHERE clause, but why can't we access outer table aliases in a subquery FROM clause? Is the table alias rewritten into the select clause?
-Tom
В списке pgsql-novice по дате отправления