Jan Wieck wrote:
>
> > My other problem is with the views: it seems not work if there is an
> > aggregate command in the SELECT. It's only my experience, or others
> > noticed it also? (The details are on the pgsql-novice (subject: view
> > and aggregate command problem))
>
> Aggregates in view's are still buggy. It is possible to
> change the grouping when doing a join from such a view and
> another relation in a way, that crashes the backend.
We'll have to implement subqueries in FROM someday - this would
allow handle aggregates in views...
Vadim