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