From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | Jan Wieck <jwieck(at)debis(dot)com> |
Cc: | s-fery(at)kkt(dot)sote(dot)hu, pgsql-sql(at)postgreSQL(dot)org, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Re: [SQL] cursor and update + view |
Date: | 1998-11-24 14:00:39 |
Message-ID: | 365ABC07.9534B144@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Hoffmann | 1998-11-24 14:49:15 | what's going on? (was: Re: [HACKERS] createdb problem) |
Previous Message | Mark Hollomon | 1998-11-24 13:43:22 | Re: [HACKERS] Tree type, how best to impliment? |
From | Date | Subject | |
---|---|---|---|
Next Message | Hitesh Kumar Gulati | 1998-11-24 14:11:52 | Re: Problem |
Previous Message | Jan Wieck | 1998-11-24 12:04:57 | Re: [HACKERS] Re: [SQL] cursor and update + view |