Re: [HACKERS] Open 6.3 issues

Jan Wieck wrote:
>
> > Views on aggregates fail
>
> Uh oh - Aggregates require a group by clause in the select.
> This is correctly copied into the query action in the views
> pg_rewrite entry. But the rewrite handler doesn't insert it
> into the parsetree. Thus a wrong execution plan in built.
>
> I'll try some things, but expect to get into trouble if the
> select from the view contains it's own grouping clauses.

There is another way of VIEW implementation: put VIEW' query
as subselect into FROM clause. The last feature is not implemented
yet. It's just a thought...

Vadim