Re: [HACKERS] Re: [SQL] cursor and update + view

Jan Wieck wrote:
>
>     There is another thing that I would like to have. The current
>     rule  system  tries  to  turn  a  qualification  that uses an
>     aggregate column of a view into a subquery. This  is  because
>     the  planner  doesn't  support plain aggregate expressions in
>     the qualification. If it would be possible  to  have  another
>     type  of Var node that points to a targetlist entry, we could
>     put the aggregates from the qualification  into  junk  TLE's.

This thing would also handled by subqueries in FROM!
Having support in planner/executor for queries like this:

select * from A, (select c, max(d) as m from B group by c) SQ
where SQ.c = A.x and SQ.m = A.y

rule system will be able to put _any_ VIEW' query into
FROM clause...

Vadim