[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] cursor and update + view
From:       Vadim Mikheev <vadim () krs ! ru>
Date:       1998-11-24 10:33:29
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]